| 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 |
| 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 | |||
Threaded Mode
