Hi guys,
Here's what my data looks like: (ignore the '.' - I'm putting it in to make the columns line up)
company day return
a...............1..........1%
a...............2..........3%
a...............3...........-5%
a...............4..........1%
a...............5..........2%
b...............1...........1%
b...............2............2%
b...............3...........3%
b...............4............5%
b...............5............6%
And I want to create a smaller table based off this data,
company day return
a.................2.............?
e.g. show me company a's return on day 2
I've been trying to use this formula:
=VLOOKUP(B13,INDIRECT(VLOOKUP(A13,A1:C7,3,FALSE)),3,FALSE)
I was trying to tell excel to first find all the company codes in the main data sheet, then match the day in order to give me one return number. This formula just gives me a #REF! error though
I'm running excel 07, windows vista just in case that's important to know.
Is there someway to combine multiple vlookups within the one formula?
Thanks!
Bookmarks