View Single Post
  #2   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 ????

Pleae ignore this request. I just retyped the data in the source table as it
was formatted to general

Thanks
Matt

Mattlynn wrote:
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