Data in Columns A, B, and C, and I need to match this data with Column E,

[sammas]

I am currently working on a spreadsheet with data in Columns A, B, and C, and I need to match this data with Column E (PORTAL BOL), specifically about BOL numbers(Column E,).

Here's what I'm looking for:

If the BOL numbers in Columns A, B, and C match with the BOL numbers in Column E, I would like the data to be validated as green.

If there is no match, I want the corresponding data to be validated as red.

Additionally, it would be constructive if there could be a visual indication of whether there is a match or mismatch for quick reference

 

[GraH - Guido]

Since I cannot open the file on my smartphone, I'm assuming the data starts at row 2, and that the matching is done on the same row


The conditional format rule can be:
Not(Isna(match(E2, A2:C2, 0))
Or countif(A2,C2,E2)>0.

If the query is that any of the numbers in E ( regardless of the row) then this solution does not work.

 

[sammas]

Since I cannot open the file on my smartphone, I'm assuming the data starts at row 2, and that the matching is done on the same row


The conditional format rule can be:
Not(Isna(match(E2, A2:C2, 0))
Or countif(A2,C2,E2)>0.

If the query is that any of the numbers in E ( regardless of the row) then this solution does not workNot(Isna(match(E2, A2:C2, 0)).

Not(Isna(match(E2, A2:C2, 0)) - It didn't worked for all row it say FALSE and

countif(A2,C2,E2)>0. this didnt worked for me

 

[sammas]

Not(Isna(match(E2, A2:C2, 0)) - It didn't worked for all row it say FALSE and

 

[sammas]

Still waiting for the help

 

[GraH - Guido]

Still without excel, going by the screenshots you can try:
Xmatch(E2:E100, ToCol(A2:C100)) if you have Excel 365 version.

 

[p45cal]

I'm assuming that you're looking for matches in only the same row as the value in column E. If that's the case there is no match at all, so your screenshot is correct, no matches, all FALSE.
In the attached, I've added conditional formatting (fyi, based on the formulae in cells G2 and H2), and changed values in three cells to show what happens when a match is found:

 

[vletm]

sammas​

What are Your expected correct results?
Your If the BOL numbers in Columns A, B, and C match with the BOL numbers in Column E
could read that You would try to match within whole columns (instead of rows).

 

[sammas]

Here's what I'm looking for:

If the BOL numbers in Columns A, B, C, and D match with the BOL numbers in Column E, I would like the data to be validated as green.

If there is no match, I want the corresponding data to be validated as red. or match or Mismatch

 

[sammas]

sammas​

What are Your expected correct results?
Your If the BOL numbers in Columns A, B, and C match with the BOL numbers in Column E
could read that You would try to match within whole columns (instead of rows).

Here's what I'm looking for:

If the BOL numbers in Columns A, B, C, and D match with the BOL numbers in Column E, I would like the data to be validated as green.

If there is no match, I want the corresponding data to be validated as red. or match or Mismatch

 

[vletm]

sammas​

Three times same sentences.
Could You please, send an Excel-file, which shows Your expected correct results?

 

[sammas]

sammas​

Three times same sentences.
Could You please, send an Excel-file, which shows Your expected correct results?

I'm currently working with BOL numbers in Columns A, B, C, and D on a sheet, and in Column E, I have corresponding Portal BOL numbers. I'm seeking assistance to implement the following checks:

Verify if the BOL numbers in Columns A, B, C, and D match with the Portal BOL numbers in Column E.
If there is a match, apply a green color to the corresponding cells in Column E. and Higled the related ROW from ABCD also in green
Establish a visual relationship between the matched rows, for instance, if Column E's number 966954 matches with Column D's row #4, both rows should be highlighted in green.
In Column F, display the row numbers where the match occurs.
Additionally:

If there is no match with any of the BOL numbers in Columns A, B, C, and D, with Column E then the corresponding cells in Column E should be colored red.
I appreciate your expertise in helping me set up these verifications and color codes

 

[p45cal]

See column F and conditional formatting in attached. It's a bit slow since I haven't bothered trying to make it efficient.

 

[vletm]

sammas​

I've asked which shows Your expected correct results?
Do You mean that all columns from A to D should be green? ... expected?
I noticed that You had used there conditional formatting which makes that file ... slow.
or
You could try to use something like this sample?
... which will give 'missed' too

My sample use more colors...
About Your In Column F, display the row numbers where the match occurs.
Did You know that there are more than one match per PORTAL BOL-row?
Press [ Do It ]-button in cell K1 ( of course, macros have to be enabled).
... then You'll see how those results come ( instead of waiting with sheet, which looks like frozen ).

 

[sammas]

sammas​

I've asked which shows Your expected correct results?
Do You mean that all columns from A to D should be green? ... expected?
I noticed that You had used there conditional formatting which makes that file ... slow.
or
You could try to use something like this sample?
... which will give 'missed' too
View attachment 86008
My sample use more colors...
About Your In Column F, display the row numbers where the match occurs.
Did You know that there are more than one match per PORTAL BOL-row?
Press [ Do It ]-button in cell K1 ( of course, macros have to be enabled).
... then You'll see how those results come ( instead of waiting with sheet, which looks like frozen ).

Thank you for the effort. Ya it worked

 

[sammas]

See column F and conditional formatting in attached. It's a bit slow since I haven't bothered trying to make it efficient.

Thank you for your effort and time to help me out with this file.