Finding Values for Multiple Ranges in one Sheet

[adnan.rehman]

Hi

Could you please help out with a formula needed to find a value for Multiple ranges. The data given below needs to be found

Name Name1 Name2 Name3
Date Number Date Number Date Number Date Number
1/2/2007 8 1/2/2007 8 1/2/2007 8 1/2/2007 8
1/3/2007 9 1/3/2007 9 1/3/2007 9 1/3/2007 9
1/4/2007 8 1/4/2007 8 1/4/2007 8 1/4/2007 8
1/5/2007 7 1/5/2007 7 1/5/2007 7 1/5/2007 7

The Result required is :

Name 1/2/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/3/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/4/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/5/2007 (Number required by using Name as first look up, Then
Date as second look up)

Name1 1/2/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/3/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/4/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/5/2007 (Number required by using Name as first look up, Then
Date as second look up)

Name2 1/2/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/3/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/4/2007 (Number required by using Name as first look up, Then
Date as second look up)
1/5/2007 (Number required by using Name as first look up, Then
Date as second look up)

Is there any formula that can be used to look up name first and then using the date cell below that name to find the number ?

[rylo]

Hi

Can you please either set up an example spreadsheet and attach to the post, or detail what cells contain what data from your example.


rylo