If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VLOOKUP Help
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! |
#2
|
|||
|
|||
VLOOKUP Help
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 "JoeL" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|