Search for a given value across 2 cells return value depends on which cell it’s found in

[Bhg1984]

I have 2 collums of candidate entries. One for foundation entries and one for higher. The entry will show a "C" in one of the 2 collums, if there isn't a "C" in either collum, theyre not entered at all.

I need a formula to look across the 2 collums for a "C" and return "F" if found in the first (foundation entry) collum, or return a "H" if found in the second collum (higher) or return " " (nothing) if no entry is found.

 

[StephenCrump]

Welcome to the Forum!

Perhaps something like this?

	A	B	C	D	E	F	G	H	I	J
1		Result					Foundation			Higher
2		F					C
3		H								C
4
5		F					C
6		F					C
7
8		H								C
9
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=IF(G2="C","F",IF(J2="C","H",""))