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'))
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'))