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
Finding a cell and returning value from a different row and column 1
countif text values to represent different numerical values 5
Seeding in Drop Down List 3
Macro to find and copy to another sheet 4
How calculate a difference btwn 2 TextBox and insert the result inthe appropriate cell 4
Make a cell with a list of values (#s, text) from other cells 3
How to list cells from two sheets that has different values in theirneighboring column? 8

Top