Check multiple columns for a value - display second value

[maximusimo]

Hi there,

I have 3 tables with codes and prices (codes are not formatted like the below). I want to enter a value in J2 and if that value is in any of the tables I want the PRICE for that table to display in K2.


I can do it for two tables where it displays one value or the other using:
=IF(ISNUMBER(MATCH(J2,A:A,0)),B3,F3)
It just looks in the first PRICE LIST CODES column and if its not there it displays the value from the second.

This could run on to more than 3 tables but thought I would start here.

Any ideas?

 

[maximusimo]

Sorry this is the image that never displayed above: