Lookup populated cell before an empty one??
 

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

Lookup populated cell before an empty one??
 

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

Lookup populated cell before an empty one??
 

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

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