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
|