Converting a formula result to a word

**Alxis** · 01-14-2014, 12:04 AM

Hi,

I have two sheets, the first called 'AF' and the other called 'POR'. For one of the columns in the 'AF' sheet I used the following formula - VLOOKUP(B2,POR!$A$2:$A$111254,1,FALSE) to retrieve a string consisting of 7 numerical digits (Ex. 4678451). Now if I want this result of 7 digits in the same 'AF' sheet to be converted to the word "YES" - how do I achieve this? (All the 7 digits numbers are different or unique). Is there some sort of REPLACE command I use here or some other means?

Please advise.

Thanks

**bebo021999** · 01-14-2014, 12:17 AM

Try:
=IF(NOT(ISERROR(VLOOKUP(B2,POR!$A$2:$A$111254,1,FALSE))),"YES","NO")

**FDibbins** · 01-14-2014, 12:23 AM

If that is the exact number that you would use to return a "Yes" answer, then 1 of 2 ways....
1. =if(cell-ref="4678451","Yes","")

2. =if(VLOOKUP(B2,POR!$A$2:$A$111254,1,FALSE)="4678451","Yes","")

If 4678451 is an actual number and not a text string, remove the ""