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

 

[Joe4]

Try this formula on one of the VLOOKLUPs that returns "Available" (let's say it is C20):
=LEN(C20)

Does it return 9? If not, it sounds like you have some extra spaces/characters in there, and that is what is causing your formula to not work as you expect.

 

[wynn89]

Hi,

you may try

=IF(TRIM(C20)="Available",A20,"N/a")

Regards,
Wynn

 

[Joe4]

you may try

=IF(TRIM(C20)="Available",A20,"N/a")

TRIM will work on "normal" spaces, but not on special characters like "non-breaking" spaces, or other special characters that you sometimes get from things off of the web. I have run into that situation a few times before. There are ways of getting around that too, once you identify what they are/where they are.