This is my answer to a similar question today. See if you can adapt it
With the text in B1, C1, D1, dates in A2:A3; data in B2:D4
date Aberdeen Celtic Rangers
23/11/2008 12000 52000 49000
24/11/2008 14000 45000 47000
25/11/2008 15000 65000 52000

In G1 enter the team to find: Rangers
In H1 locate its position in the list of teams with =MATCH(G1,B1:D1,FALSE) ;
this returns 3 since the team is in position 3
In G2 use =TODAY() and in H2 use =MATCH(G2,A2:A4,FALSE), this returns 3
since today's date in the third position
Locate the required data with =INDEX(B2:D4,H2,H1) This returns the expected
52000

Combine all this into one formula as
=INDEX(B2:D4,MATCH(TODAY(),A2:A4,FALSE),MATCH(G1,B 1:D1,FALSE))

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"airsg" wrote in message
...
I am trying to lookup Ex: "JOE" in column A and return the value
corresponding to "JOE" in column B. The problem is that there are 5
"JOE"s
listed and I want to run formulas in five cells to show the 5
corresponding
values to "JOE" from column B. Any help with this would be appreciated.
--
Steve