Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have been trying to search for the answer but can't quite find it. I am
trying to do what I can only think of to call a two level lookup. Basically it requires to pieces of data to uniquely identify the record. In the example below I will have a record that contains a business unit and an account next to each other. I want to look back at another worksheet to pull the amount. Business Unit Account Amount 00001 9000 $5 00002 9000 $10 00002 9001 $2 00002 9002 $13 00003 9002 $8 00003 9003 $21 So for example if I had another worksheet set up with the following. 00002 9002 how do i pull the value $13? For simplicity sake we can assume the upper right hand value of '00001' is in cell A1. Thanks to anyone with any advice. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
sum sub levels. | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |