View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Vlookup help menue is wrong ????

Hi ya

Can somone please tell me why this vlookup from the help menu does not
compute

= VLOOKUP("DI-328", A2:D6, 3, FALSE) * (1 + VLOOKUP("DI-328", A2:D6, 4, FALSE)
)

I get #value!

Many Thanks
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200911/1