Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula ?
I got 3 columns in excel. First two is ID & Name, third column is a subset of
the 2nd Column. Now, I want the corresponding ID's for my 3rd column (which should be looked up in first 2 columns) in my 4th column. ID,Name,Subset-name,Subset-ID? -- Failing to plan is planning to fail |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula ?
On Sun, 25 Apr 2010 01:24:04 -0700, Joe
wrote: I got 3 columns in excel. First two is ID & Name, third column is a subset of the 2nd Column. Now, I want the corresponding ID's for my 3rd column (which should be looked up in first 2 columns) in my 4th column. ID,Name,Subset-name,Subset-ID? Assuming your data are in columns A to C from row 2 to row 100. In cell D2, try the following formula: =INDEX(A$2:A$100,MATCH(C2,B$2:B$100,0) Change the 100's to fit the size of your data in columns A (and B). Copy the formula down column D as far as you have data in column C. Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula ?
Try the INDEX() MATCH() combination instead of VLOOKUP() when the lookup
value is not the 1st column in the array... =INDEX(A:A,MATCH(C2,B:B,0)) -- Jacob (MVP - Excel) "Joe" wrote: I got 3 columns in excel. First two is ID & Name, third column is a subset of the 2nd Column. Now, I want the corresponding ID's for my 3rd column (which should be looked up in first 2 columns) in my 4th column. ID,Name,Subset-name,Subset-ID? -- Failing to plan is planning to fail |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |