search and input data from one workbook into another

[chris86t]

I have 2 workbooks - a.xls, b.xls.

i want the value of A1 in a.xls to = ROW?:COL20 in b.xls by searching ROW# by a name in COL3

I've tried using vlookup without success.

 

[SkipVought]

Hi,

Instead of a cryptic explanation, please post a concrete example of the value in A1 and the lookup range in b.xls that illustrates what you want to do, including the value you expect to have returned.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[chris86t]

Sorry about the way I asked. I figured it out though. Vlookup worked.