Text search with custom answer

[MrsFixIt]

My formula is almost working...please help!
From Column Z use LEFT to pull the first character from a text string in column R
If the text string in R begins with N = answer "not applicable"
if the text string in R begins with F, use vlookup and look for the value in another sheet column A
if the value is found, bring the match to column Z, if the text string is not found, answer "not in data"

my formula keeps kicking out #VALUE!
=OR((LEFT(R5517,1)="N"),"Not Applicable",IFERROR9VLOOKUP((R5517,SHEET3A:A,1FALSE)"Not in Data'))

 

[jasonb75]

You need IF, not OR.

=IF(LEFT(R5517,1)="N","Not Applicable",IFERROR(VLOOKUP(R5517,SHEET3!A:A,1,FALSE),"Not in Data"))

A couple of missing commas and stray brackets, but other than that you had the right idea.