Vlookup help menue is wrong ????

  • Thread starter Mattlynn via OfficeKB.com
  • Start date
M

Mattlynn via OfficeKB.com

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
 
M

Mattlynn via OfficeKB.com

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

Thanks
Matt
 
Top