lookup

[George]

I have 3 spreadsheet files 2 are look up tables. Basically
they contain catalog information from 2 different companies.

On the main spreadsheet if comany A is put in say cell A1

I want to look up the information in that companies catalog eor look up tabl
and move the pricing info to the main sheet for the part that is selected.

I'm not sure how to go about it?

 

[Norman Harker]

Hi George!

It looks like you need a formula like:

=IF($A$1="ABC Co",VLOOKUP(A7,ABC_Table,2,FALSE),IF($A$1="DEF
Co",VLOOKUP(A7,DEF_Table,2,FALSE),""))

Based on the entry in A1 you look up the entry in A7 in the
appropriate table. If A1 is "" it returns "". If you want to cover A7
being blank use:

=IF(A7="","",IF($A$1="ABC
Co",VLOOKUP(A7,ABC_Table,2,FALSE),IF($A$1="DEF
Co",VLOOKUP(A7,DEF_Table,2,FALSE),"")))
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.