An example would be helpful.
Absent that....Here's one approach:
This formula finds the C1 value in col_B and return the corresponding
value from col_A
Does that help?![]()
=INDEX(A1:A10,MATCH(C1,B1:B10,0))
An example would be helpful.
Absent that....Here's one approach:
This formula finds the C1 value in col_B and return the corresponding
value from col_A
Does that help?![]()
=INDEX(A1:A10,MATCH(C1,B1:B10,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks