Vlookup with variable lookup value

[Ormie]

Hello,

Is it possible for a VLOOKUP to have a multiple lookup value.

For example:

=VLOOKUP(A1,'Data'!$A$1:$D$1000,2,FALSE)

If the lookup value in A1 is empty it can look at a different lookup value in A2?

Thanks in advance,

Chris

 

[Phuoc]

Try this:

=VLOOKUP(IF(A1<>"",A1,A2),'Data'!$A$1:$D$1000,2,FALSE)

 

[Ormie]

Perfect, thank you very much!

 

[Phuoc]

You're welcome!