Referencing Corresponding Values
My mistake. This formula works. Thanks very much!
"Domenic" wrote:
First, sort your table by Column B, in ascending order, as follows:
Hughes A
Arenas B
Dixon C
Profit D
Peeler E
Blake F
Hayes G
Jamison H
Jeffries I
Haywood J
Then try the following array formula that needs to be confirmed with
CONTROL+SHIFT+ENTER, not just ENTER...
=INDEX(Sheet2!A3:A12,MATCH(TRUE,ISNUMBER(MATCH(LOO KUP(CHAR(ROW(INDIRECT("
65:74"))),Sheet2!B3:B12,Sheet2!A3:A12),Sheet1!A2:E 2,0)),0))
Hope this helps!
In article ,
bob wrote:
Let me explain my problem in another way. In Sheet1, there is a list of 5
names.
A2 = Arenas
B2 = Haywood
C2 = Hughes
D2 = Jamison
E2 = Jeffries
In Sheet2, there is a list of 10 names and a letter (A through J) beside
each name. The 5 names in Sheet1 are included in the 10 names in Sheet2.
A3 = Blake B3 = F
A4 = Arenas B4 = B
A5 = Hughes B5 = A
A6 = Dixon B6 = C
A7 = Profit B7 = D
A8 = Peeler B8 = E
A9 = Hayes B9 = G
A10 = Haywood B10 = J
A11 = Jamison B11 = H
A12 = Jeffries B12 = I
I want to determine the smallest letter (A) from Sheet2 and place the
corresponding name (Hughes) in Sheet1 cell F2--only if that name appears on
the list in Sheet1. If not, I want to find the next smallest letter with a
matching name.
Can you help?
Thanks very much,
Bob
|