Vlookup giving wrong answer

**toclare84** · 08-26-2010, 07:49 AM

Hi Everyone,

I have a workbook. it gives a rate for a worker when they enter their area 1 postcode and area 2 postcode against their age. i have a seperate tab for the different postcode areas and a seperate tab for the different rates. the postcode finder works great. the problem i am having is that when it finds the rates it is giving me the rate infront of the one it should give.

i have attached my workbook for you. the man is aged 36 and it should give the rate for area g, but it keeps giving me the rate for a man aged 35 and area f. i think it might need to +1 in the match section, but i cant seem to get it right!

any ideas?

**NBVC** · 08-26-2010, 07:57 AM

Looks like your indexed ranges are off by one row and off by one columns

should be, for example, in J4:

=IF(A4="","",INDEX(RATES!$A$5:$P$50,MATCH(A4,RATES!$A$5:$A$50,0),MATCH(D2,RATES!$A$4:$P$4,0)))

**toclare84** · 08-26-2010, 08:01 AM

Hi,

Thanks for the quick reply, i have tried it and it still is giving the one behind for the area codes.

any other thoughts?

**NBVC** · 08-26-2010, 08:02 AM

Try copy/pasting the formula again.. you probably copied it before I made a small adjustment.

**toclare84** · 08-26-2010, 08:41 AM

Thats Amazing! thank you very much your a massive help as always!!

**NBVC** · 08-26-2010, 08:53 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save