Vlookup or Offset question

Not sure how to accomplish this so i will attempt to explain. Any
assistance would be greatly appreciated!

Sheet1 - consists of four columns of data for females with the first column
(A) being years from 20 - 65, and the other three being whole numbers.
Sheet2 - consists of four columns of data for males with the first column
(A) being years from 20 - 65, and the other three being whole numbers.
Sheet3 - consists of the following:
A2 - name
B2 - Age in years (calculated from two dates)
C2 - Gender (M or F)
D2, E2, F2 - numbers that are needed to come from either Sheet 1
or Sheet 2 based on the year (B2) and the Gender (C2)

Basically I need to be able to fill D2, E2, and F2 on Sheet3 with the values
from the corresponding year on either Sheet1 or Sheet2 depending on whether
the gender is M or F.

Is this possible? If so, any examples would be greatly appreciated. TIA!

Bill

Try this in D2 on Sheet3 and drag across:

=VLOOKUP($B2,INDIRECT("Sheet"&IF($C2="M",2,1)&"!
A"),COLUMN()-2,0)

If you'd like the workbook that I used to test this, e-
mail me directly with a copy of your original post.

HTH
Jason
Atlanta, GA

-----Original Message-----
Not sure how to accomplish this so i will attempt to
explain. Any
assistance would be greatly appreciated!

Sheet1 - consists of four columns of data for females
with the first column
(A) being years from 20 - 65, and the other three being
whole numbers.
Sheet2 - consists of four columns of data for males with
the first column
(A) being years from 20 - 65, and the other three being
whole numbers.
Sheet3 - consists of the following:
A2 - name
B2 - Age in years (calculated from two dates)
C2 - Gender (M or F)
D2, E2, F2 - numbers that are needed to come
from either Sheet 1
or Sheet 2 based on the year (B2) and the Gender (C2)

Basically I need to be able to fill D2, E2, and F2 on
Sheet3 with the values
from the corresponding year on either Sheet1 or Sheet2
depending on whether
the gender is M or F.

Is this possible? If so, any examples would be greatly
appreciated. TIA!

Bill


.

Excellent-A! THANKS!

Bill
"Jason Morin" wrote in message
...
Try this in D2 on Sheet3 and drag across:

=VLOOKUP($B2,INDIRECT("Sheet"&IF($C2="M",2,1)&"!
A"),COLUMN()-2,0)

If you'd like the workbook that I used to test this, e-
mail me directly with a copy of your original post.

HTH
Jason
Atlanta, GA

-----Original Message-----
Not sure how to accomplish this so i will attempt to
explain. Any
assistance would be greatly appreciated!

Sheet1 - consists of four columns of data for females
with the first column
(A) being years from 20 - 65, and the other three being
whole numbers.
Sheet2 - consists of four columns of data for males with
the first column
(A) being years from 20 - 65, and the other three being
whole numbers.
Sheet3 - consists of the following:
A2 - name
B2 - Age in years (calculated from two dates)
C2 - Gender (M or F)
D2, E2, F2 - numbers that are needed to come
from either Sheet 1
or Sheet 2 based on the year (B2) and the Gender (C2)

Basically I need to be able to fill D2, E2, and F2 on
Sheet3 with the values
from the corresponding year on either Sheet1 or Sheet2
depending on whether
the gender is M or F.

Is this possible? If so, any examples would be greatly
appreciated. TIA!

Bill


.