Lookup populated cell before an empty one??
Your welcome
"Elsmith" wrote:
Thank you Mike, thats perfect!!
--
Elsmith x
"Mike H" wrote:
Try,
=LOOKUP(2,1/(A1:Q1<""),A1:Q1)
Mike
"Elsmith" wrote:
A B C
1000 3500 200
My query is about excel picking up the right cell based
on population. So IF C is populated use C, IF C is NOT
populated and B is use B but if B is also not populated
use A.
I dont know if a function that uses the cell that is
populated and furthest to the right will work IE: If A B &
C were populated it would use C but if only A was
populated it would use A??
Or if there is a function that picks up a number before a balnk cell??
--
Elsmith x
|