Formula ?
in [Programming]
|
From: Joe on 25 Apr 2010 04:24 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
From: Lars-�ke Aspelin on 25 Apr 2010 04:41 On Sun, 25 Apr 2010 01:24:04 -0700, Joe <Joe(a)discussions.microsoft.com> 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
From: Jacob Skaria on 26 Apr 2010 10:19 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
|
Pages: 1 Prev: loop VBA request Next: Tagging formatting (cells with mixed formatting) |