Vlookup

[Lodebo]

Hi,

I'm using this vlookup function :

=VLookup(B6;[KW49_benodigd.xlsx]Mstock_grondstoffen!$B$22:$AD$84;29;False)

As you can see "KW49" is a part of the worksheetname
How can i replace "KW49" by a cell value ?

Best regards,
L.

 

[fredericofonseca]

use function INDIRECT()

so your formula would look like
«VLOOKUP(B6,INDIRECT("["&$F$1&"_benodigd.xlsx]Mstock_grondstoffen!$B$22:$AD$84",29,FALSE)

where $F$1 is a cell containing the prefix of the other worksheet


see working example a

http://spreadsheetpro.net/how-to-ma...a-worksheet-in-excel-and-google-spreadsheets/

also look at using INDEX + MATCH as it may behave better

http://www.mbaexcel.com/excel/why-index-match-is-better-than-vlookup/

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886