help with ifvlookup function.

**jeromephoto** · 12-30-2009, 06:28 AM

Hello,
Trying to calculate shipping cost from table on seperate sheet.If shipping is over $200 than its free otherwise need to lookup value on seperate sheet. On the seperate sheet have table shipping with 2 columns.one with subtotal amount i.e (0-54.99) and then second column cost at 5.95. the following was my formula which doesn't work.

=if(h38>=200,0,Vlookup(h38,shipping,2,0)).

Thanks-jeromephoto

**somesoldiers** · 12-30-2009, 06:56 AM

can you post an example of your workbook please?

**dominicb** · 12-30-2009, 07:03 AM

Good morning jermomephoto

...and welcome to the forum!!

Originally Posted by jeromephoto

the following was my formula which doesn't work.
=if(h38>=200,0,Vlookup(h38,shipping,2,0)).

In essence, the formula is correct and should work, however we need to know how it doesn't work (incorrect result, error message, if so which one etc).

Basically, the named range of shipping (what range does this cover?), needs to contain the same value as in H38. Is this why it is not finding it?

Try posting a mocked up worksheet so we can take a look.

HTH

DominicB