Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup / Hlookup iterations
I am trying to figure out how to do multiple iterations of vlookup or hlookup
in one cell. For example, I have the following table: Project 1 Start Date 1/10/2008 Revenue 100,000 Net Profit 20,000 Project 2 Start Date 2/10/2008 Revenue 200,000 Net Profit 30,000 Project 3 Start Date 5/10/2008 Revenue 500,000 Net Profit 40,000 I am trying to enter a formula that will find Project 2's Revenue, or 200,000. Is there a way to use vlookup (or any other function)? Any suggestions would be much appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup - HLookup | Excel Discussion (Misc queries) | |||
hlookup & vlookup together | Excel Discussion (Misc queries) | |||
vlookup & hlookup | Excel Worksheet Functions | |||
How do I use Vlookup or Hlookup? | Excel Discussion (Misc queries) | |||
Vlookup and Hlookup | Excel Worksheet Functions |