excel v lookup

Question on a spreadsheet with two cells not using vlookup correctly:
---------------------------------

The spreadsheet has one column per client, and shows which stocks are held and this holding as a % of the total portfolio.

The spreadsheet populates using a VLookUp formula, extracting the relevant data from another excel spreadsheet.

One client/column does not populate the relevant data for a particular stock, even though it uses the same formula as the other cells in the column and there are no obvious mistakes. The formula for these two cells are as follows:

Holding:
=IF(ISNA(VLOOKUP(A138,'Z:\Yahoo NS Valuations\nsValuation\2013\09.2013 NS\[nsValuation 2013.09.13.xlsm]E Brett'!$A$5:$L$196,4,FALSE))=TRUE,0,VLOOKUP(A138,'Z:\Yahoo NS Valuations\nsValuation\2013\09.2013 NS\[nsValuation 2013.09.13.xlsm]E Brett'!$A$5:$L$196,4,FALSE))

Percentage:
=IF(ISNA(VLOOKUP(A139,'Z:\Yahoo NS Valuations\nsValuation\2013\09.2013 NS\[nsValuation 2013.09.13.xlsm]E Brett'!$A$5:$N$196,14,FALSE))=TRUE,0,VLOOKUP(A139,'Z:\Yahoo NS Valuations\nsValuation\2013\09.2013 NS\[nsValuation 2013.09.13.xlsm]E Brett'!$A$5:$N$196,14,FALSE))

We have tried copying over cells where the formula works, checking the cell format, checking the reference cell and moving the reference cell destination.
doctorbillTechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
The Holding is looking at A138 whereas the Percentage is looking at A139. Is that correct?
0
D_WongCommented:
Your formula looks fine.
Check the reference data doesn't have leading / trailing spaces and/or single quotation marks.

Alternatively can you post example ?
0
barry houdiniCommented:
to clarify:

I assume the ISNA part of the formula is kicking in and you get zero returned for both formulas? If so then it menas that A138/A139 isn't found in the lookup range - what's in those cells?

regards, barry
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
doctorbillTechAuthor Commented:
those cellesare empty
0
doctorbillTechAuthor Commented:
Thanks all - given me some pointers to look at
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.