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.

Hi,

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

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

On Saturday, June 9, 2012 9:34:08 PM UTC-5, markd038 wrote:
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|
+-------------------------------------------------------------------+



--
markd038

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

On Sun, 10 Jun 2012 02:34:08 +0000, markd038 wrote:

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.



--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...