Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |