Hi
As attached sample, how can i find the data in column C(blue) matched with the data in Column A (yellow)?
And copy the column C data into column B.
Thanks
Hi
As attached sample, how can i find the data in column C(blue) matched with the data in Column A (yellow)?
And copy the column C data into column B.
Thanks
Last edited by okl; 07-24-2017 at 10:52 PM.
Hi okl,
You need an Index Match formula like:
=INDEX(C:C,MATCH(A2,C:C,0))
Index Match A to C.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks