VLOOKUP Help

[JoeL]

Please bare with me, but I've never used the vlookup function and I'm having
difficulties.

I have two spread sheets with file numbers in column A. I need to know if
the files in spreadsheet two (smaller data set, named "RS2008") are within
spreadsheet one (larger data set, named '2008'). If so, I need a "1"
populated into spreadsheet one, column U (data in columns B-T).

Please help how I would accomplish this task.

Thank you!

 

[B. R.Ramachandran]

Hi,

In U2 of Spread Sheet one, enter the following formula and drag to fill down
the column.

=IF(ISNUMBER(MATCH(A2,[RS2008.xlsx]Sheet1!$A:$A,0)),1,"")

The part "[RS2008.xlsx]Sheet1!$A:$A" corresponds to the entire column A in
spread sheet two. You don't have to type it in the formula. Rather select
the actual data range in column A or the entire column A range (by clicking
on "A" above the cell A1) of that spread sheet, and this action inserts it in
the formula, including the correct file extension depending on which version
of Excel is used.

If this is helpful, please give a feedback by clicking on the "Yes" button.

Regards,
B. R. Ramachandran