srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,851
- Office Version
- 365
- Platform
- Windows
Hi All,
I need to match two lists and find the matched value. The short list has 16 digits invoice number, while the lookup table has long list with the same invoice numbers but with the extention “-SBOO2”, “-SBOO3”,
I need to match the invoice number. I am using the conditional formatting with the following formula.
=SUMPRODUCT(--ISNUMBER(SEARCH(A4"*",$F$4:$F$10)))
Where Column A has the long list. I highlighted the long list.
Please advise.
I need to match two lists and find the matched value. The short list has 16 digits invoice number, while the lookup table has long list with the same invoice numbers but with the extention “-SBOO2”, “-SBOO3”,
I need to match the invoice number. I am using the conditional formatting with the following formula.
=SUMPRODUCT(--ISNUMBER(SEARCH(A4"*",$F$4:$F$10)))
Where Column A has the long list. I highlighted the long list.
Please advise.