How to find a Text exists in a column or not

Hi Team,

Please suggest the function for the below requirement please.

I have 6 Columns

First 4 Columns will be given by the Client

1) Column A - Table Names
2) Column B - FAIL Count
3) Column C - PASS Count
4) Column D - Table which we need to Check

Requirement: 5th and 6th need to be Populated based on Excel Function. We need to Check Column D Table Check with Column A and pick the related the Counts and show it in E and F Columns

Please find the Worksheet attached.

Thanks!
Kiran

As long as there are no duplicate entries in the Table Name column enter this in cell E2 and fill down and across to F16:

Formula:

Please Login or Register  to view this content.

Does this do what you want?

Edit: By the way some of the entries in the Table Name column have a trailing space. If the entries in the Table Check column aren't exactly the same this formula is not going to detect it. Consider cleaning the data in column A.

Or this 1...
=IFERROR(INDEX(B$2:B$16,MATCH($D2,$A$2:$A$16,0)),"")

Happy to help, thanks for the feedback