Hello,
Hoping someone can assist me with a solution for an index/match situation as per sample.
On sheet 1 there is a list of colours and I would like to check sheets 2,3,4, and if there is a match to place it in col f,g,h.
Now a colour in sheet1 will only appear in one of the sheets 2,3,4.
Last edited by gilnic; 05-11-2019 at 09:10 AM. Reason: title
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
In "F2"Formula:
Please Login or Register to view this content.
In "G2"Formula:Please Login or Register to view this content.
In "H2"Formula:Please Login or Register to view this content.
Ensure by pressing ctrl+shift+enter
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
In F2 then dragged across.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Hello,
Thank you both for responding with assistance for my query.
@avk I tried your solution but it did not work for me.I have enclosed the sample sheet.
@ kvsrinivasamurthy Thank you that has worked as required.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks