formula only works in first row

[Gabbrielle]

Hey Excel ninjas. Kinna looked all over for an answer to this and got to the point where registering to a forum seems like the only way.

I have a formula that only seem to work in the first row. Pretty simple "if found then copy" type of formula but still don't work.

Any genius can help me with this?

Thanks tonstest data.xlsx

[Norie]

Is it the formula in column B on Sheet2?

What is it supposed to do? Find the Gender from Sheet1 by looking up the RefNum?

[Gabbrielle]

ya pretty much. I'm trying to put in sheet2 the gender in sheet one

[Norie]

Try this.

Please Login or Register  to view this content.

[Special-K]

Or
=VLOOKUP(A2,Sheet1!A$2:B$16,2,FALSE)

[Gabbrielle]

Norie...I'll sing your praise to my children and my grandchildren!

Thanks tons. <3

[Norie]

No problem.

[Gabbrielle]

Thanks for the answer also. Norie was faster but you were super cool to take the time to help like that.

Love from Montreal