Hi There
I have a spreadsheet with 4 columns
A = Date
B = Description
C = Value / Amount
D = Lookup Column for matching with B
D has a long list of values like Burger King, McDonalds, Starbucks.
What I want to do is get the value from C where a word in B matches any of the words in D
Example
Column A
Date
01/01/2015
Column B
Description
POS W/D BURGER K
Column C
Amount
$20
Column D
BURGER K
MCDONALDS
STARBUCKS
requirement - return the value of C into column E
What I have tried is the following:
=IF(ISNUMBER(FIND("MCDONALDS",B2)),C2,IF(ISNUMBER(FIND("BURGER K",B2)),C2,0))))
The above works well but for every additional unique takeaway place I need to add an additional find and there is a limitation on the number of characters in the function.
Any ideas are really appreciated.
B
Bookmarks