Conditional Vlookup

[Benjaminmin]

Hi everybody,

I am populating a sheet looking up some values in another sheet, but I would like to add a constraint to the vlookup so that if the first vlookup doesnt return a value, then it does a second lookup.

So first it would run:
=VLOOKUP(A179,RBS!$T$32:$V$44,3,0)

If that returns a #N/A, then it should run
=VLOOKUP(A179,RBS!$U$32:$V$44,2,0)

Is that possible?

Thank you very much in advance

 

[hatman]

=if(isna(VLOOKUP(A179,RBS!$T$32:$V$44,3,0)),VLOOKUP(A179,RBS!$U$32:$V$44,2,0),VLOOKUP(A179,RBS!$T$32:$V$44,3,0))

 

[Benjaminmin]

=if(isna(VLOOKUP(A179,RBS!$T$32:$V$44,3,0)),VLOOKUP(A179,RBS!$U$32:$V$44,2,0),VLOOKUP(A179,RBS!$T$32:$V$44,3,0))

EDIT: Never mind, I had made a mistake. Your formula works perfectly Hatman! Thank you very very much for a quick and perfect solution