Hi all,
I'm trying to come up with the correct function to check if the text in cell in an adjacent cell matches a value from a list of possible values. And if it does, return a value from another list of possible values. Does that make Sense????
I tried :=IF(E4=$H$4,G4," ")(E4=$H$5,$G$5," ")(E4=$H$6,$G$6," ")(E4=$H$7,$G$7," ")(E4=$H$8,$G$8," ")(E4=$H$9,$G$9," ")(E4=$H$10,$G$10," ")(E4=$H$11,$G$11," ")(E4=$H$12,$G$12," ")
The attachment is a sample of my table.
Any Help much appreciated.