On 7 Mar, 15:40, Tom Hutchins
wrote:
Try this:

=VLOOKUP(A2,Sheet2!$A:$G,MATCH(B2,Sheet2!$1:$1,0)+ 1,FALSE)

assuming your first row of data on Sheet1 is in row 2, and your headings on
Sheet2 are in row 1.

Hope this helps,

Hutch



" wrote:
Hello

Can you please help me with the following.

I need to lookup up a value in the cell A1 of sheet 1 and return the
value in sheet 2 of the column next to the the column with a heading
matching the value of B2 in sheet 1.

For example.

Sheet 1

Ref * Type
1 * *Man
2 * *Woman
3 * *Man
4 * *Child

Sheet 2

Ref * Man * Man type * Woman * Woman type * Child * Child type
1 * * Peter * x * * * * * * * Sarah * * *y * * * * * * * * * Lily
x
2 * * John * *y * * * * * * * Jane * * * *z * * * * * * * * * Max * *x
3 * * Bob * * y * * * * * * * Jane * * * *x * * * * * * * * * Alice
x
4 * * Fred * *z * * * * * * * Jane * * * *x * * * * * * * * * Ruby
y

So I would expect the returned value on sheet 1 to be:

Ref * *Type * * *Result
1 * * * Man * * * x
2 * * * Woman *z
3 * * * Man * * * y
4 * * * Child * * *y

Any help on this one greatly appreciated- Hide quoted text -

- Show quoted text -

Hutch - thankyou, it's worked a charm. Mike, thanks for all your
suggestions on this one as well - much appreciated.

Megan