Urgent help pls #NA vlookup error

Hi,

Can someone please tell me what's wrong with the formula? I have googled like mad and I cant seem to get any solution.
My result is always #NA.

I've even tested the 2 cells i.e. =B2='Starhub total Lines'!A6 and it comes as TRUE..so what is wrong then??

Thanks.

Hi,

Your reference in VLOOKUP to 'Working (2)' should start from B:C. Please change the formula as following, it works.

=VLOOKUP(A8,'Working (2)'!B:C,1,FALSE)

Originally Posted by Fotis1991

Try using INDEX & MATCH functions

Formula:

Please Login or Register  to view this content.

and it works! fantastic.. thanks v much!

Originally Posted by cbatrody

Hi,

Your reference in VLOOKUP to 'Working (2)' should start from B:C. Please change the formula as following, it works.

=VLOOKUP(A8,'Working (2)'!B:C,1,FALSE)

thanks cbatrody.. ive already used the index solution..

Hi friend,

please find the attached sheet

Hope Enjoy

MaSs