Multi-Variable Lookup help

OTPM · #1 05-04-2011, 08:33 AM

Hi Erin
Is it possible to past a copy of your spreadhseet here so we can try and help you.
OTPM

ebolton · #2 05-04-2011, 09:35 AM

This is a more detailed sample of the spreadsheet that I am working from. The Data is on the Data tab and the schedule I want to create is on the Fall 2011 tab.

OTPM · #3 05-05-2011, 03:13 AM

Quote:

Originally Posted by ebolton

This is a more detailed sample of the spreadsheet that I am working from. The Data is on the Data tab and the schedule I want to create is on the Fall 2011 tab.

Hi Erin
I have had a play with your spreadsheet however I have been unable to find a solution. I am sure there is a formula that will do it and hopefully someone with more detailed skills than I will be able to help. I know you can do it with VBA but it will need a VBA expert to help.
Good luck.
Tony

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Variable fields?	Emalee77	PowerPoint	0	01-30-2011 05:58 PM
Creating Lookup in Excel	vikash kumar	Excel	2	12-06-2010 06:50 AM
Variable Table_Array in VLOOKUP	pdab09	Excel	3	11-23-2010 05:28 AM
Inputting variable data	axy	Word	0	09-08-2009 04:50 PM
Using the LOOKUP Command	Grapejuice	Excel	2	10-15-2008 02:02 PM