I am having a problem with Vlookup.
In this case cell J78 reads ='table of contents'!f20
In cell E72 i have a vlookup formula that looks at J78 and then looks in a range of i70:j71 and inputs the value from column 2 into cell e72.
So i am guessing that since i am getting a #n/a it means vlookup is reading the formula instead of the result in j78.
Is there a way to fix it?
Thanks
Last edited by JESSIER4025; 02-02-2012 at 09:58 AM. Reason: formula edit
Check that 'table of contents'!f20 exactly matches the text that is in I70:I71. There should be no extra spaces, chars...
and that you included a FALSE 4th argument in your VLOOKUP for exact matching.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hardly seems worth using VLOOKUP if your table is only i70:j71 - a couple of IFs would do, and you can check for absent values:
=IF(J78=I$70,J$70,IF(J78=I$71,J$71,"not present"))
Hope this helps.
Pete
awesome!! that was it. i left off part of it.
thanks!!
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks