| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you find the differences between two mailing lists in Exce | Excel Discussion (Misc queries) | |||
| comparing two list and need to find exact in both lists | Excel Worksheet Functions | |||
| Compare two lists of data to find new entries | Excel Discussion (Misc queries) | |||
| compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
| How can I compare two lists of data (channel lineups) - find what. | Excel Worksheet Functions | |||
Linear Mode
