Vlookup not working, where am I going wrong?

[forestavekids]

Pretty straight forward, can't figure out why my vlookup function will not work.

Please see attached, should be pulling data from columns C and D into column O.

Thanks!

[Jonmo1]

You have 2 problems.

1) In O1, your formula is
=VLOOKUP(N1,C1:D1,2,0)
It's only looking in C1 for a match to N1, which it is not a match.
That should be
=VLOOKUP(N1,C$1:D$5200,2,0)


2) The values in C are TEXT values (beginning with ' ), but values in N are Numbers
Numbers will not match with Text strings.

Try
=VLOOKUP(N1&"",C$1:D$5200,2,0)

[Special-K]

Column N is numbers
Column C is text

[forestavekids]

So basically having the same issue again..

Can someone take a look?

[forestavekids]

sheet is attached.

[Jonmo1]

It's the exact same 2 problems.
Your formula is only covering 1 row of the lookup range G1:H1, it should be G$1:H$320

You have 2 columns, 1 is numbers (G), the other is TEXT (E)
Try copying a blank cell,
Highlight column E
Right Click - Paste Special - Values - Add - OK.