Not sure if FIND is the right way to do this, but say I have a list of of things not sorted into order (and won't be sorted), like so -
A B
3 A
1 G
7 D
5 E
9 P
6 L
5 W
In cell C1 is a variable, and I want D1 to FIND that variable in the list in column A, and return the value corresponding in Column B.... but the list in A can't be sorted and won't be in order.... any ideas?
A B
3 A
1 G
7 D
5 E
9 P
6 L
5 W
In cell C1 is a variable, and I want D1 to FIND that variable in the list in column A, and return the value corresponding in Column B.... but the list in A can't be sorted and won't be in order.... any ideas?