Please see attached spreadsheet
I AM USING FORMULA BELOW
=IF(ISNUMBER(SEARCH(L$35,$B15)),$C15,"")
but it returns number in column c ifor approx match
SEE COLUMN 58
I NEED A FORMULA THAT ONLY WORKS FOR AN EACT MATCH
Thanks for any help
Carroll
Please see attached spreadsheet
I AM USING FORMULA BELOW
=IF(ISNUMBER(SEARCH(L$35,$B15)),$C15,"")
but it returns number in column c ifor approx match
SEE COLUMN 58
I NEED A FORMULA THAT ONLY WORKS FOR AN EACT MATCH
Thanks for any help
Carroll
There are no exact matches.
Please add a space at the end in M35 (Replace "GAZELLE MEDEO T10" with "GAZELLE MEDEO T10 "
and the formulas are working as expected.
Last edited by HansDouwe; 08-20-2023 at 01:48 AM.
How aboutFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks