If errors

[Harvey12]

Hi all,

I have recently been doing a formula which looks at an external file. This vlookup brings back whether a particular language is 'Available' or not for our service manuals to be written in.

There are two outcome the Vlookup can return 'Available' or 'No'.

I am currently trying to write and IF formula to look at the outcome and pull the part number from the first cell if the answer is available.

I have written it correctly: =IF(C20="Available",A20,"N/a")

But for some reason they all show as 'N/a', the formula doesn't seem to recognise the 'Available'

Can someone please assist!!!

Many thanks
Harvey

 

[gaz_chops]

What exactly is in cell C20? Available or 'Available'

 

[Harvey12]

Available

 

[gaz_chops]

Then it should work! What is in A20?

 

[Harvey12]

A part number eg: 1234/56789

 

[gaz_chops]

Strange! Can you upload a sample to dropbox and post the link here?

 

[Harvey12]

Unfortunately I can't - The files I am currently dealing with are confidential.

The formula is written exactly as described - I cannot understand why it will not work

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-questions/848420-if-errors.html. Not sure why you re-posted this question when you already had replies in the original that you did not respond to.

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).