Hi Michelle,

Enter the formula at B3 as below

=IF(OR([Prices.xls]sheet1!$A$1:$A$3=A3),VLOOKUP(A3,[Prices.xls]sheet1!A$1:B$3,2,FALSE),VLOOKUP(A3,[Prices.xls]sheet2!A$1:B$3,2,FALSE))

Enter this pressing keys <CTRL<SHIFT<ENTER and braces {} will appear
around the formula.

Copy down till B5. And for next column that is C, copy the formula and
make changes as below:

=IF(OR([Prices.xls]sheet1!$A$1:$A$3=A3),VLOOKUP(A3,[Prices.xls]sheet1!A$1:B$3,3,FALSE),VLOOKUP(A3,[Prices.xls]sheet2!A$1:B$3,3,FALSE))


I hope this works for you. Do send me the feedback to help you over
this if any error occur.

For now, do it for just two sheets. If this is working for you I will
send you the formula for three sheet (tabs)


Thanks,

Shail



MichelleS wrote:
I need help with LOOKUP or VLOOKUP.

I have two EXCEL 2000 documents ( Estimates.xls and Prices.xls).

(this is a snapshot of ESTIMATES.xls)
A B C
1
2 Product Description Est Price
3 400 _____ $____
4 600 _____ $____
5 900 _____ $____

(this is a snapshot of PRICES.xls, Tab or Sheet 1)
A B C
1 Product Description Price
2 400 Red XYZ $47.00
3 500 Blue SPQ $68.00

(this is a snapshot of PRICES.xls, Tab or Sheet 2)
A B C
1 Product Description Price
2 600 Green XYZ $40.00
3 800 Brown SPQ $88.00

(this is a snapshot of PRICES.xls, Tab or Sheet 3)
A B C
1 Product Description Price
2 900 Black XYZ $70.00
3 950 White SPQ $38.00

I would like to type a product code into cell A3 on ESTIMATES.xls and have
it automatically populate cells B3 and C3 with info from the PRICE.xls. The
PRICE.xls has 3 tabs or sheets that need to be searched in order to populate
correctly.

Any help with this is appreciated.
(ps: I'm a beginner so please use details in wording)
Michelle