Vlookup

[ksebring]

Looking to have excel lookup a value based off criteria from other workbooks. I tried the following and it doesn't return the value in column 39. Any help with this would be appreciated.

=IFERROR(VLOOKUP(B3,'G:\{TIME TRACKING}\Kevin - Test\[Test_Master.xlsm]JANUARY'!$B$32,39,FALSE),"")

 

[Jonmo1]

You seem to be missing half of your lookup range address

=IFERROR(VLOOKUP(B3,'G:\{TIME TRACKING}\Kevin - Test\[Test_Master.xlsm]JANUARY'!$B$32:$AN$1000,39,FALSE),"")

 

[ksebring]

That worked great. Thank you so much. If I wanted to search more than one workbook, how would i add this to the string?

 

[ksebring]

Also i realized that my lookup field has "T-0600 Project management" but my B3 lookup only reflects "T-0600". I changed the last section to True to look for the T-0600 but its not returning the correct value.

 

[Jonmo1]

If I wanted to search more than one workbook, how would i add this to the string?

You would need 2 vlookup formulas, 1 for each book

Also i realized that my lookup field has "T-0600 Project management" but my B3 lookup only reflects "T-0600".

Try changing the lookup value from
B3
to
B3&"*"

And keep the FALSE as the 4th argument