| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
=IF, If only I knew the answer
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
| This should be simple if I knew any better... | Excel Programming | |||
| v Column??? In an interview, asked if i knew it...HELP | Excel Discussion (Misc queries) | |||
| I THOUGHT I knew what I was doing | Charts and Charting in Excel | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
Threaded Mode
