CODEWITHSUNDEEP
excelexcel-formulavba
kosta p
kosta p

Reputation: 13

Vlookup using two strings

I am using the Vlookup to pull data, but the data table row that I want data from may be using a different text string, I was hoping someone can help me out with the correct syntax to use (I can't get it to work) - this is what I have so far:

=IFERROR(VLOOKUP("String 1"&"String 2",'excelbook'!$A$2:$Y$75,B$407,FALSE),0)

Would totally appreciate your help, thanks!

Upvotes: 0

Views: 1321

Answers (1)

maoizm
maoizm

Reputation: 719

If you are looking for the row which contains String 1 OR String 2 in the first column, you can use the following formula:

=IFERROR( VLOOKUP("String 1",'excelbook'!$A$2:$Y$75,B$407,FALSE), IFERROR(VLOOKUP("String 2",'excelbook'!$A$2:$Y$75,B$407,FALSE),0) )

Upvotes: 2

Related Questions