How to search value in external workbook if a match then return value

**Lilbird8** · 02-22-2009, 08:41 PM

User enters ID # in cell I2 in workbook "Eval_Rprt_02-33" I need it to compare values in second workbook "Eval_log" if IDs match then return "Date performed" from column "F" and auto enter it into cell G2 in Eval_Rprt_02-33. Do both the workbooks have to be stored in the same folder and do they both have to open at the same time? Not an advanced user in macros or VB.

**martindwilson** · 02-22-2009, 09:21 PM

vlookup will look in closed workbook, it doesnt have to be in same folder.
but needs the path.
easiest way is to construct your vlookup with both books open
on first book insert/function/vlook up
when you get to fill in the "table array" part click in it,then click second workbook
select the field you want with the cursor
enter the column number manualy
in range_lookup enter false
click ok
this will now be linked.
i am assuming you know how to use vlookup!

**Lilbird8** · 02-23-2009, 12:02 AM

Thank you for your quick reply. No I have not used vlookup and when I tried to use the Lookup Wizard from the tools menu it said to click Add-ins then select the Lookup Wizard. I get the message Microsoft Excel cannot access the file lookup.xla and I am trying to find out why.