Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
V/HLookup
I have a table of product codes with 20 different prices for each product
code that sit on sheet 2 of the workbook. Price Range prod code 1 2 3 4 a 10 20 30 40 b 15 25 35 45 c 17 19 21 22 On Sheet 1, in cells A6 to A50 I want to enter various product codes, and depending on what price range I have entered in cell A1, I would like to be able to return the price next to the product code in column B ie: Price range A1 =4 Product code=A6 =b Returns price of 45 in B6 Price range A1 =2 Product code=A7=c Returns price of 19 in B7 If anyone can help me simplify this using lookup table it would be great Thanks If anyone can help -- charliep |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hlookup help | Excel Discussion (Misc queries) | |||
HLOOKUP | Excel Worksheet Functions | |||
hlookup | Excel Worksheet Functions | |||
Hlookup? | Excel Worksheet Functions | |||
Hlookup | Excel Discussion (Misc queries) |