Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Issue
I have a problem that I require help on.
I am working on a big spreadsheet. I have to pull information from one sheet into another. However I have 2 lookups to do. Is this possible. example - Info Sheet A B C 1 Manchester ABC Total -230.30 2 Manchester DEF Total +123.34 Example - Working Sheet A B C 1 Store Name ABC Total DEF Total 2 Manchester I need to lookup "Manchester" and "ABC Total" to give me "-230.30" in a cell. Any Ideas if this is possible, or another solution!! Thanks in advance Jayz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
LOOKUP Command Issue | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) |