The examples shifted a bit. "column" age 42 wrapped down in the
post. Sorry if it looks confusing.

EXAMPLE OF WORKSHEET B
Spouse Age Participant Age
40 41 42
38 2.5 2.6 2.7

39 2.9 3.0 3.1

40 3.2 3.3 3.4


Trying again with less space.

On Nov 11, 10:47*am, clk wrote:
Hi. *I have a worksheet (WorksheetA.xls) that calculates age of
employee and age of spouse. *I have a separate worksheet
(WorksheetB.xls) that is set up like a grid. *Age of participant
(employee) across the top (row 8), and age of spouse coming down
column A. *I need to find age of employee on my WorksheetA.xls in cell
J20. *Go to the second spreadsheet (worksheetB.xls) and go across row
8 to the age of employee. *Then go back to first sheet, find age of
spouse and go down column a on worksheetb to find that age.

So for example, if on WorksheetA my employee is 41 and his spouse is
40. *I need to "lookup" on WorksheetB, *first employee age of 41 then
go down and find row with spouse age (40). *So what I need returned is
3.3 to worksheetA.

EXAMPLE OF WORKSHEET B
Spouse Age * * * * * * * * * *Participant Age
* * * * * * * * * * * * * * * * *40 * * * * * * * * 41
42
38 * * * * * * * * * * * * * *2.5 * * * * * * * * 2.6
2.7

39 * * * * * * * * * * * * * *2.9 * * * * * * * * 3.0
3.1

40 * * * * * * * * * * * * * *3.2 * * * * * * * * 3.3
3.4

I hope I am clear in my description. *Thank you for any assistance.