Google sheets formula help

[lizmorton1990]

Hi,

I need help with a formula. I want certain text to display if someone adds any text into a certain cell, but only if that course is in a list. So far I have:

=iferror(vlookup(J2,'CF Core & Supplementary Courses'!A:C,3,0), "")

But I need to add in if cell FR has any text or numbers added (doesn't matter what it is), so if someone adds 'Yes' to column FR then the above formula will trigger and if the J2 is found in the CF core tab then it will return column C, but if J2 is not found I need the cell to be blank regardless of what they have added to column FR.

 

[etaf]

so if someone adds 'Yes' to column FR then the above formula will trigger

on what sheet the same sheet as J2 is entered
AND
is it anywhere in column FR - so if column FR is completely blank , then the formula =iferror(vlookup(J2,'CF Core & Supplementary Courses'!A:C,3,0), "") will not be used
if so
then
IF( COUNTA(FR:FR)=0, "", iferror(vlookup(J2,'CF Core & Supplementary Courses'!A:C,3,0), ""))

 

[lizmorton1990]

Hi Wayne,

Thanks for replying. It might help if I attach what I am seeing. Column J has a list of codes that are also in tab CF Core & Supplementary Courses in column A. So on this example on the bottom row I have added a date in column FR, what I ideally want is for column FS to show 'CHECK before discontinuing' but if column FR doesn't have anything in it then column FS should be blank. That text in column FS i.e 'CHECK ....' is from tab 'CF Core & Supplementary Courses' in column C.

I am just trying to get people to stop and think when adding a date into column FR.

 

[etaf]

so its not anywhere in column FR - just on the same row
where is the lookup formula putting results from column C ?

what I ideally want is for column FS to show 'CHECK before discontinuing' but if column FR doesn't have anything in it then column FS should be blank.

=IF( FR="", "", "check before discontinuing")
not sure where the lookup comes into play now

so if someone adds 'Yes' to column FR then the above formula will trigger and if the J2 is found in the CF core tab then it will return column C, but if J2 is not found I need the cell to be blank regardless of what they have added to column FR.

return column C to what cell

Sorry i seem to making a bit of an issue here , as i'm not following exactly