If statement with vlookup

[albert211994]

Hi! I'am trying put a value in a selected cell using if and vlookup.

Here is the formula

=IF($N13="","",IF(VLOOKUP($N13,Directory!$F:$F,1,0)=$N13,"G",IF(VLOOKUP($N13,Directory!$G:$G,1,0)=$N13,"S",""))

It returns "G" if the value returned from vlookup from column F of directory is equal to N13 but if it is false it returns #n/a instead doing vlookup again in column G of directory.

Hope you can help.
Thank you.

 

[FlameRetired]

Hi albert211994 and welcome aboard.

If I understand correctly try this formula. BTW the IFERROR function only works in Excel 2007 and newer. Let us know if you are using other version. If G:G doesn't contain $N13 you will need to wrap this in another IFERROR ... IFERROR(AllBelowFormula,"")

=IFERROR(IF($N13="","",IF(VLOOKUP($N13,Directory!$F:$F,1,0)=$N13,"G")),IF(VLOOKUP($N13,Directory!$G:$G,1,0)=$N13,"S",""))

 

[jeffreybrown]

How about...

=IF(N13="","",IF(COUNTIF(Directory!F:F,N13),"G",IF(COUNTIF(Directory!G:G,N13),"S","")))

 

[FlameRetired]

Yeah. Better.

 

[albert211994]

It worked!
Thank you very much!

 

[jeffreybrown]

You are most welcome. We are very happy to help...