Vlookup retreiving cell value ahead of the actual cell

[Ang]

I am trying to create a vlookup, but the results keep retreiving the cell value from one cell ahead of actual value? I pasted the formula for 48 rows and it is consistently retreiving the value ahead of the actual.

For example: the actual value I am wanting placed in A6 is in H4 but it is retreiving the cell value in H5.



=VLOOKUP(A6,$G$1:$H$48,2)

 

[Andrew Poulsom]

You need INDEX/MATCH for that:

=INDEX($F$1:$F$48,MATCH(A6,$G$1:$G$48))

 

[Ang]

Thanks Andrew . .I will give it a try!

 

[NBVC]

If you need exact match, then add a FALSE argument to your vlookup()...

Like so: =VLOOKUP(A6,$G$1:$H$48,2,FALSE)