have been trying to use this formula in the attached spreadsheet =IF(B7=K$5&"*",C7,"NOMATCH")
i want to return the number in column c when column b matches k5 (using * wildcard)
formula doesn't work
help would be appreciated
Thanks Carroll
have been trying to use this formula in the attached spreadsheet =IF(B7=K$5&"*",C7,"NOMATCH")
i want to return the number in column c when column b matches k5 (using * wildcard)
formula doesn't work
help would be appreciated
Thanks Carroll
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks