Thread: formula issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chrisbmo2000 chrisbmo2000 is offline
external usenet poster
 
Posts: 14
Default formula issue

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?