Snake Eyes
Board Regular
- Joined
- Dec 14, 2010
- Messages
- 103
- Office Version
- 365
- 2016
- Platform
- Windows
Hi All,
I have a Lookup formula in a cell that is capturing the cell value of the last cell in a range with actual data. In that range, each cell gets it's value from a simple cell reference or formula. The cells with a formula sometimes result in a dash (hyphen) "-" symbol.
My issue is that the lookup formula captures the hyphen in the last cell in the range if that cell has the hyphen and not the last cell with actual data.
How can I prevent this?
I have already changed the formatting of those cells to hide the hyphen but the lookup still sees the value because it is technically nor a blank cell.
Here is my LOOKUP formula that captures the hyphen...
=LOOKUP(2,1/(O159:O165<>""),O159:O165)
I tried this but I then capture the last blank cell...
=LOOKUP(2,1/(O159:O165<>"-"),O159:O165)
I can't figure out the correct syntax to ignore blanks AND hyphens.
Kindest Regards,
Snake Eyes
I have a Lookup formula in a cell that is capturing the cell value of the last cell in a range with actual data. In that range, each cell gets it's value from a simple cell reference or formula. The cells with a formula sometimes result in a dash (hyphen) "-" symbol.
My issue is that the lookup formula captures the hyphen in the last cell in the range if that cell has the hyphen and not the last cell with actual data.
How can I prevent this?
I have already changed the formatting of those cells to hide the hyphen but the lookup still sees the value because it is technically nor a blank cell.
Here is my LOOKUP formula that captures the hyphen...
=LOOKUP(2,1/(O159:O165<>""),O159:O165)
I tried this but I then capture the last blank cell...
=LOOKUP(2,1/(O159:O165<>"-"),O159:O165)
I can't figure out the correct syntax to ignore blanks AND hyphens.
Kindest Regards,
Snake Eyes