Vlookup issue

[Eric Tsang]

Dear all

Have no idea why the Vlookup is not working ..

Kindly advise, in the attached file

SIC_ADult and SIC Child , return with a wrong figure

Appreciate your help

Eric

[Phuocam]

Try ...

=VLOOKUP($D9,Net!$A$1:$P$142,11,0)

[Eric Tsang]

Thanks but it is still not working

[BadlySpelledBuoy]

Have a look at the amended attachment.

BSB

[BadlySpelledBuoy]

Add the part in red below:

=VLOOKUP($D9,Net!$A$1:$P$142,15,FALSE)

And amend the column number from 11 to 15

BSB

[southward]

Hi Eric,

Your VLOOKUP is looking at Column K of the Net Sheet.

Change the "11" in your formula to a "16".

=VLOOKUP($D9,Net!$A$1:$P$142,11)

=VLOOKUP($D9,Net!$A$1:$P$142,16)

Hope this is helpful.

Cheers

[Eric Tsang]

Dear, it works, how come ?!

[Olly]

Use a similar formula to the one which is already in Column G:

=INDEX(rate,MATCH($D9,Services,0),MATCH(I$8,Items,0))

[BadlySpelledBuoy]

In what way is it "not working"? That doesn't give us much information.

BSB

[gregous]

Hi
Did you get it fixed by now?

[gregous]

Hi
Works for me ok but just replacing the formula with the correct cell reference: =VLOOKUP($D9;Net!$A$1:$P$142;15;FALSE) 15 instead of 11 for SIC_ADT and 16 of 12 for SIC_CHD

What else doesn't work?