Hi,
Hoping this might be a real simple one...
I'm trying to apply formula to a column but to get it to stop when there is no value for it to apply to. So when the 23rrd cell in column E is blank to just ignore it (I don't want N/A to show)
This is my formula:
LOOKUP(D3,Customers!A$2:A$15,Customers!D$2:D$15)
I tried:
=E:E=LOOKUP(D3,Customers!A$2:A$15,Customers!D$2:D$15)
but that just sends back "FALSE"
Bookmarks