Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup. Match. Lookup. Wtf? | Excel Discussion (Misc queries) | |||
Double lookup without using vlookup? | Excel Worksheet Functions | |||
IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET | Excel Discussion (Misc queries) | |||
Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions | |||
VLOOKUP - dealing with lookup_value differences | Excel Worksheet Functions |