If and vlookup nested formula

abramlett

I'm looking to create a formula that if a cell matches this criteria, vlookup a different column info for multiple cell matches as a nested formual.

If Product Identifier matches A, search for org name in a different sheet and tell me if it exists there, if product identifier matches B, search for org name in a 3rd different sheet and tell me if it exists there, etc, etc.

John_Foster

This is doable. the formula would need to look something like the below, with the relevant details and ranges in the VLOOKUP parentheses.

=IF([Product Identifier]@row = "A",VLOOKUP(),IF([Product Identifier]@row = "B",VLOOKUP(),""))

John