VLOOKUP Help


J

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!
 
Ad

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top