One way...
With your data starting on row 2.
Enter this formula in A2 and copy down as needed:
=INDEX(C:C,MATCH(B2,D:D,0))
One way...
With your data starting on row 2.
Enter this formula in A2 and copy down as needed:
=INDEX(C:C,MATCH(B2,D:D,0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks