View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
meganerema meganerema is offline
external usenet poster
 
Posts: 1
Default 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!