Match criteria and give result

[rvr ramana]

Hello All,

Due to confidential data i have changed all the details in the excel. Please find the attached excel which contains multiple tabs and the required details are as follows:

Am doing migration for entire organization of 4000 users and i need to track according to the branches (ie. finance, admin.. etc which i changed to Team A, Team B etc). The First tab "Raw Data" will contain list of all the users in the organization (4000 users). On migrating the user system in Sheet 1 if i changes the status to "Complete" then it should match all the other sheets (Team A/B/C/D..etc) and if it matches in any of the sheets it should say as "y" in that particular coloum in Sheet1 or "Raw Data). whcih i have given the sample.

Please find the attached.

Regards.
RVR.Ramana

[rvr ramana]

attachment.

[Pete_UK]

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

EDIT: I see that you have done so now.

Pete

[KOKOSEK]

Check attached file.

	A	B	C	D	E	F	G	H
22	22742	21	Windows 10 Entpz	Pending
23	24854	22	Windows 10 Entpz	Pending
24	21838	23	Windows 10 Entpz	Completed			Y
25	21158	24	Windows 10 Entpz	Completed			Y

Into E2:

Please Login or Register  to view this content.

and drag down

Into F2:

Please Login or Register  to view this content.

and drag right and down.

EDIT: attachment changed.

[rvr ramana]

Apologies Pete, i will take care of from next time.

[rvr ramana]

Hi,

Thanks for the formula and it indeed worked, but the problem is it worked only for first couple of coloumns in my original file. Not sure where am doing wrong , am attaching my original file for you to check (Request not to share on public Domain).Could you please check what exactly am doing wrong in the formulas and guide me in proper way.

Thanks.
RVR

[KOKOSEK]

Due to usage INDIRECT insisde you have to name sheets EXACTLY as describe in row 1.
Check picture below:
If in F1 is "Cust Rel-Mgmt" sheet can't be named "Cust Relationship Mgmt", etc. As you see when description matching between values in row 1 and sheet names it works (Database, Digital).

Capture.JPG

[rvr ramana]

Hi,

It worked perfectly fine, thanks for the guidance. Appreciate your help.

Regards.
RVR.Ramana

[KOKOSEK]

Happy to help.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.

[rvr ramana]

Hey, not sure the way to do. Is that i need to select the Reply to Thread and type Solved?

Or is that on top i need to rate :Drop Down?

Sorry never did it and know its a silly think to ask but learning for me.

Regards.
RVR.Ramana

[Pete_UK]

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete