ExcelBanter - Vlookup help menue is wrong ????

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup help menue is wrong ???? (https://www.excelbanter.com/excel-worksheet-functions/247372-vlookup-help-menue-wrong.html)

Mattlynn via OfficeKB.com

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

Mattlynn via OfficeKB.com

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

All times are GMT +1. The time now is 09:48 AM.