Lookup problem

[sweeneyr82]

Hello,
I have two sheets, one with two variables, HH ID and HH type. The other sheet has one variable individual ID (which obviously has more entries as there are more individuals than HHs - some IDs repeat when individuals are in the same household). I am trying to assign HH type to each individual, where as before household type is only available at the household level. I have tried using the lookup function where I lookup the individual ID, where the lookup vector is the HH ID in the HH sheet, and where the result vector is the HH type in the HH sheet. It doesn't work as it simply repeats the first value obtained from the formula, or has an error in it when I drag it down.
My formula is:

=LOOKUP(A2,HH!A:A,HH!B:B)
where A2 is Individual ID in the individual sheet, HH!A:A refers to the lookup vector, the first/A column in the HH sheet which is the HH ID, and HH!B:B is obviously the result vector, the second/B column in the HH sheet which is HH type.

See attached


Can anyone advise?

[PeteABC123]

Hi sweeneyr82:

Try

=VLOOKUP(A2,HH!A:B,2,FALSE)

Copy down.

Pete

[sweeneyr82]

That has worked, thanks.