Hi i have the below formula which does not work when trying to add wildcard lookup. Trying to make the lookup "Life Stages" a wildcard like this "*life*" is not working.
=IFERROR(LOOKUP(2,1/((Billed2!B:B=272)*(Billed2!A:A=C20*1)),Billed2!D:D),0)+IFERROR(LOOKUP(2,1/(('Ohio Current month spend'!A:A="*Life*")*('Ohio Current month spend'!B:B=C20*1)),'Ohio Current month spend'!C:C),0)*1.15
Try replacing this:
'Ohio Current month spend'!A:A="*Life*"
With this:
SEARCH("Life",'Ohio Current month spend'!A:A)
On a side note...
You should avoid using entire columns as range references in this formula. Use smaller specific ranges.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks