VLOOKUP NA Data missing error even when data is present

Hi,

Need some guidance on what I am missing here.

What I am trying to achieve is lookup against a range of SKU's from a master sheet and have the SKU appear in a column next to a prouct - this will form part of a wider piece to use an IF statement to display Yes or No dependant on the LOOKUP result.

All sheets are in the same workbook and when I have tried am getting various NA errors about data not being available.

Would appreciate if someone could have a look at the workbook and advise.

For reference:

Live on Store is the source data
Cell to populate result is Ranged on Store on Computers sheet (I can copy to other sheets when required)

Thanks in advance

Chris

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Hi, and welcome to the forum

Maybe

Formula:

Please Login or Register  to view this content.

I think all you need in U2 is:

Please Login or Register  to view this content.

but I might be misunderstanding what you're asking for.

It's pretty simple.

MATCH returns the position of a particular value in an array. So it takes F4, and returns how many rows down that same thing is in the 'Live on Store'!N2:N20 range. If there is no match, if it throws the #N/A errror.

Then it's wrapped with ISNUMBER, which returns TRUE if it contains a number (like a successful MATCH) or a FALSE if it does not (such as an error code from a failed MATCH).