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

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

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