ludjaybouffard
New member
- Joined
- Jul 9, 2015
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Good Morning/Afternoon whever you are!
In short i want this IFERROR(LOOKUP(2,1/A$3:A$13="x"),C$3:C$13),0) to be able to ignore the blank cell!
But it keeps giving me a result of 0 because it keeps getting the first cell of the list regardless if its blank or not!
This is my first post so i cannot give you a visual...
Thanks,
In short i want this IFERROR(LOOKUP(2,1/A$3:A$13="x"),C$3:C$13),0) to be able to ignore the blank cell!
But it keeps giving me a result of 0 because it keeps getting the first cell of the list regardless if its blank or not!
This is my first post so i cannot give you a visual...
Thanks,