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