Find value for one cell from 2 different lists.
 

value for cell L55 when K33 has two options. K33 = Bags or sack and form that
I need to get values from 2 different lists and a 3rd cell L13 has a volume
to start from. I am using L13 as my starting cell. Formula is.
=lookup(L13,A117:A191,H119:H191) for when K33 = sacks.
and if K33 = bags. =lookup(L13,A117:A191,K117:K191).
Regards
Chris

Find value for one cell from 2 different lists.
 

Sorry. How do I get it to work from both lists with one formula.
Thanks
Chris.

"Chris" wrote:

value for cell L55 when K33 has two options. K33 = Bags or sack and form that
I need to get values from 2 different lists and a 3rd cell L13 has a volume
to start from. I am using L13 as my starting cell. Formula is.
=lookup(L13,A117:A191,H119:H191) for when K33 = sacks.
and if K33 = bags. =lookup(L13,A117:A191,K117:K191).
Regards
Chris

Find value for one cell from 2 different lists.
 

Try
=LOOKUP(L13,A117:A191,IF(K33="sacks",H117:H191,IF( K33="bags",K117:K191)))

--
Jacob


"Chris" wrote:

Sorry. How do I get it to work from both lists with one formula.
Thanks
Chris.

"Chris" wrote:

value for cell L55 when K33 has two options. K33 = Bags or sack and form that
I need to get values from 2 different lists and a 3rd cell L13 has a volume
to start from. I am using L13 as my starting cell. Formula is.
=lookup(L13,A117:A191,H119:H191) for when K33 = sacks.
and if K33 = bags. =lookup(L13,A117:A191,K117:K191).
Regards
Chris