=IF, If only I knew the answer

[markd038]

Hi all,
I'm trying to come up with the correct function to check if the text i
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

+-------------------------------------------------------------------
|Filename: =IF.pdf
|Download: http://www.excelbanter.com/attachment.php?attachmentid=404
+-------------------------------------------------------------------

 

[Spencer101]

Hi all,
I'm trying to come up with the correct function to check if the text i
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.

Hi,

If you could post an example of this but in an Excel file it would b
far easier to help you out with this

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

Hi Mark,

Am Sun, 10 Jun 2012 02:34:08 +0000 schrieb markd038:

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," ")

try:
=IFERROR(INDEX($G$4:$G$18,MATCH(E4,$H$4:$H$18,0)),"")

for excel versions earlier than 2007:
=IF(ISERROR(MATCH(E4,$H$4:$H$18,0)),"",INDEX($G$4:$G$18,MATCH(E4,$H$4:$H$18,0)))


Regards
Claus Busch

 

[Don Guillett]

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.


+-------------------------------------------------------------------+
|Filename: =IF.pdf |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=404|
+-------------------------------------------------------------------+

In additon to the file, post the logic of what you want with examples....

 

[Stan Brown]

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????

Yes, but you don't want a bunch of nested IFs, you want VLOOKUP or
HLOOKUP.