Try something like this, named ranges use for simplicity

=IF(AND(ISERROR(VLOOKUP(B3,rng1,2,0)),ISERROR(VLOO KUP(B3,rng2,2,0))),VLOOKUP(B3,rng3,2,0),IF(AND(ISE RROR(VLOOKUP(B3,rng2,2,0)),ISERROR(VLOOKUP(B3,rng3 ,2,0))),VLOOKUP(B3,rng1,2,0),VLOOKUP(B3,rng2,2,0)) )

Please tick Yes if this helps

Peter Atherton

"DejanFlo" wrote:

Hello,

I have to find data in multiple cell range and return corresponding value:

Example: I have 3 tables with same type of data, but diferent lookup subject.

Then I have to find subject in any of 3 ranges and get corresponding values
for that record.

Regards