Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VlLOOKUP function with MATCH
Hi,
I tried to use the VLOOKUP function with MATCH to locate the price of specific type of a pipe by type and height (see table enclosed). But as you can see the result is wrong. In some cases, for instance, type 150/150 gives the correct answer while pipe type 120/180 gives wrong answer. What is wrong? Using Office XP Thanks, Amnon -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com |
#2
|
|||
|
|||
Without looking into your attachmentn I am guessing that vlookup probably
needs to lookup an exact match instead of approximate and this you can achieve by inserting a 0 after the column number as follows:- =vlookup(lookup_value,lookuprange,columnnumber,0) Notice a 0 in the formula above most people won't open an attachment So next time submit the actual formula by pasting it in the body of the message If the above does not resolve post your formula. "Amnon Wilensky" wrote in message ... Hi, I tried to use the VLOOKUP function with MATCH to locate the price of specific type of a pipe by type and height (see table enclosed). But as you can see the result is wrong. In some cases, for instance, type 150/150 gives the correct answer while pipe type 120/180 gives wrong answer. What is wrong? Using Office XP Thanks, Amnon -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com |
#3
|
|||
|
|||
Hi Amon,
something like the following should work : =INDEX(D6:H18,match(E21,C6:C18,0),match(E23,D5:H5, 0)) HTH FxM Amnon Wilensky a écrit : Hi, I tried to use the VLOOKUP function with MATCH to locate the price of specific type of a pipe by type and height (see table enclosed). But as you can see the result is wrong. In some cases, for instance, type 150/150 gives the correct answer while pipe type 120/180 gives wrong answer. What is wrong? Using Office XP Thanks, Amnon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
I want to use the MATCH function with the AVERAGE function but I . | Excel Worksheet Functions | |||
Match Function arguments | Excel Worksheet Functions |