Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with using Vlookup formula
I have a Price List in Sheet1 Like
A B C 1 Product Pack Rate 2 Mango Jam 500 Gm 20.00 3 Mango Jam 250 Gm 18.00 4 Pinapple Jelly 500 Gm 35.00 5 Pinapple Jelly 250 Gm 25.00 Continued...to Last In Sheet2 I A2 = Validation List of all Pruduct B2 = validate formula is =Indirect(a1) C2 = formula is =vlookup(b2,rate,2,0) The problem is that every time it shows the rate of first pack (i.e. mango 500gm or 250gm), if I choose other product in A2 also. But I want to put rate automatically in C2 according my Product and Pack selection. Is there any solution for above. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with copy/paste VLOOKUP formula | Excel Discussion (Misc queries) | |||
PROBLEM WITH INDIRECT & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Vlookup/If? Formula problem? | New Users to Excel | |||
Problem with VLOOKUP formula | Excel Worksheet Functions | |||
Vlookup, What is correct formula for problem below? | Excel Worksheet Functions |