Someone please help, I can't figure it out.
Based on columns on one sheet, I want corresponding values to list on a separate sheet. I need to exclude anything that is not a match.
I have attached an example of what I need.
Thanks!!!!!
Someone please help, I can't figure it out.
Based on columns on one sheet, I want corresponding values to list on a separate sheet. I need to exclude anything that is not a match.
I have attached an example of what I need.
Thanks!!!!!
See attached:
Formula used in A2:
copied down and to the right.Please Login or Register to view this content.
Formula used in A11:
copied down and to the right.Please Login or Register to view this content.
Note: both formulas are confirmed with CTRL+SHIFT+ENTER instead of just ENTER. This makes them array formulas and makes the { } brackets appear.
If you adjust anything in the formulas, you must reconfirm with CSE keys before copying down and/or over.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks a million! That worked like a charm!
KUDOS!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks