Hi all,
In my spreadsheet i want to populate a cell with a value dependent o
the result of two other cells and I would like some help with the
vb
line to do this.
I know it can be written as follows in 3 lines of code:
If Range("A1").Value = "Referee" AND Range("B1").Value = "U21" The
Range("G23").Value = "Value 1"
If Range("A1").Value = "Referee" AND Range("B1").Value = "U19" The
Range("G23").Value = "Value 1"
If Range("A1").Value = "Referee" AND Range("B1").Value = "U17" The
Range("G23").Value = "Value 1"
but really what I want is to evaluate with one line of code to say i
A1 = "Referee" AND B1 is any of "U21", "U19", "U17" then G23
"Value1"
Hope I have made myself clear enough and any help would b
appreciated.
TIA
Seamu
--
SO
-----------------------------------------------------------------------
SOS's Profile:
http://www.excelforum.com/member.php...nfo&userid=540
View this thread:
http://www.excelforum.com/showthread.php?threadid=26156