No, the = sign is there. I am still trying to figure out where the problem
resides.

"Max" wrote:

Ahh, did you forget the equal sign "=" ? It should have worked as well for
YOU as it did for me. If it's not the equal sign issue, then it sounds like
you were hit with another problem over there, that of your B12 being
pre-formatted as TEXT (unknown to you but of course). Just re-format B12 as
either general or number (via FormatCells), then click inside the cell B12,
re-confirm the formula to trigger it. You need to *re-confirm* the formula,
merely re-formatting the cell will NOT trigger it. Satisfy yourself that it
works well. Then go back to the earlier response, do some justice there by
re-rating it correctly. My exacting QC standards require that only thoughts
which work/help get posted.
--
Max
Singapore
---
"Fernando@Sartorius" wrote:
You are on the right idea, the lookup command is not working for some reason.
I copied to B12: LOOKUP(2,1/(B16:B35<""),B16:B35) and that is what it's
being displayed. It did not run a formula.