How to Highlight Cell After match Both data ???

[krunal123]

 

[Joe4]

It is not clear exactly what you are trying to match, or what "qualifies" as a match.
Remember, while your question is familiar to you, we know nothing about it.
Please explain in detail the logic of how this is supposed to work.

 

[krunal123]

It is not clear exactly what you are trying to match, or what "qualifies" as a match.
Remember, while your question is familiar to you, we know nothing about it.
Please explain in detail the logic of how this is supposed to work.

I was try particular number find to Invoice Number

EX. EXP/001/20-21

i was match Search "001" In Invoice Number And Match other list D: I Column to match "001"

if than match both list after highlight D:I list & highlight in cell...

This trick use for office data matching , logical Matching.

Pleased, Help me ,

I was try but , i don't know how to update formula & match up both data ?? Pleased Help me.........

 

[Joe4]

i was match Search "001" In Invoice Number And Match other list D: I Column to match "001"

Unfortunately, your second description is not any less confusing than your first.
It looks like maybe you are trying to match on the number in between the two "/" in the invoice number, but I cannot tell if you are trying to highlight it, or return a "Y" or "N". It is very unclear and confusing.

But here is code that you can use that will pull the number between the two "/" in your invoice number.
For an invoice number in cell A1, this formula will return that value:

=TRIM(MID(SUBSTITUTE(A2,"/",REPT(" ",100)),100,100))

Maybe that will give you the missing piece you need?