Help with vlookup formula

[The_Rock]

Hi Folks

I'm trying to use the following formula but it keeps defaulting to the value if false i.e. ""
=IF(ISNA(VLOOKUP(J8,$A$2:$F$14,6,FALSE))="CISTWE Reject","Rejected","")

Basically, in the column that its looking up, there are three values. I only want it to show 'rejected' if the result of the lookup is 'CISTWE Reject'.

Appreciate your thoughts.

Cheers!

 

[Jonmo1]

You have to use 2 seperate vlookups.
1 to test for error
1 to test if it = xxx

Try like
=IF(ISNA(VLOOKUP(...)),"",IF(VLOOKUP(...)="CISTWE Reject","Rejected",""))

 

[The_Rock]

Brilliant, Thanks Jonmmo1!!