Find value for one cell from 2 different lists.

C

Chris

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with value between 2 cells and return greater value. 6
2 different INDIRECT data validation lists from one 4
Finding Corresponding Cell Value 2
lookup value from different workbook 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Can different drop down lists be displayed depending on the value. 1
how do have 2 conditional formats for one cell 2
to had the value show in one cell if a different cell is clicked o 5

Top