I get #value! after using vlookup.......Im trying to multiply the price per
unit by the quantity and then add the shipping the formula is
=sum(F18*B18+G18) F18 gets its info from the vlookup formula which is
=IF(ISNA(VLOOKUP(C18,Table1,3,FALSE)),"",VLOOKUP(C 18,Table1,3,FALSE)) any
ideas?

On Wed, 30 Apr 2008 22:47:33 -0700, chrisbmo2000
wrote:

I get #value! after using vlookup.......Im trying to multiply the price per
unit by the quantity and then add the shipping the formula is
=sum(F18*B18+G18) F18 gets its info from the vlookup formula which is
=IF(ISNA(VLOOKUP(C18,Table1,3,FALSE)),"",VLOOKUP( C18,Table1,3,FALSE)) any
ideas?

It looks like you have provided a value in C18 that is not found in
the table and thus giving the cell F18 to hold "".
Trying to multiply that "" with the number in B18 gives #VALUE! error.

So, what is the expected result in the case C18 can not be found in
the table?

/Lars-Åke

First, you don't need =sum()

=f18*b18+g18
would work ok. But I'd use ()'s:
=(f18*b18)+g18

You could change the =vlookup() to return a 0 instead of text ("" is text).
=IF(ISNA(VLOOKUP(C18,Table1,3,FALSE)),0,VLOOKUP(C1 8,Table1,3,FALSE))

Or you could change the formula:
=(n(f18)*b18)+g18




chrisbmo2000 wrote:

I get #value! after using vlookup.......Im trying to multiply the price per
unit by the quantity and then add the shipping the formula is
=sum(F18*B18+G18) F18 gets its info from the vlookup formula which is
=IF(ISNA(VLOOKUP(C18,Table1,3,FALSE)),"",VLOOKUP(C 18,Table1,3,FALSE)) any
ideas?

--

Dave Peterson

Thanks for the options but Im still getting #value! it says it refers to
empty cells
any more ideas?

"Dave Peterson" wrote:

First, you don't need =sum()

=f18*b18+g18
would work ok. But I'd use ()'s:
=(f18*b18)+g18

You could change the =vlookup() to return a 0 instead of text ("" is text).
=IF(ISNA(VLOOKUP(C18,Table1,3,FALSE)),0,VLOOKUP(C1 8,Table1,3,FALSE))

Or you could change the formula:
=(n(f18)*b18)+g18




chrisbmo2000 wrote:

I get #value! after using vlookup.......Im trying to multiply the price per
unit by the quantity and then add the shipping the formula is
=sum(F18*B18+G18) F18 gets its info from the vlookup formula which is
=IF(ISNA(VLOOKUP(C18,Table1,3,FALSE)),"",VLOOKUP(C 18,Table1,3,FALSE)) any
ideas?

--

Dave Peterson

GOT IT SOLVED THANKS ALOT EVERYONE

"chrisbmo2000" wrote:

I get #value! after using vlookup.......Im trying to multiply the price per
unit by the quantity and then add the shipping the formula is
=sum(F18*B18+G18) F18 gets its info from the vlookup formula which is
=IF(ISNA(VLOOKUP(C18,Table1,3,FALSE)),"",VLOOKUP(C 18,Table1,3,FALSE)) any
ideas?