VBA equaivalent of the IF worksheet functions

[andyandy12345]

I am trying unsuccessfully to work through a range where I need two conditions to be met and to output result that has to be looked up. In Excel the formula would look something like this "=IF(AND(X2<>"text", G2<>24),4,"x") - but this is limited for my requirements.

The value in x2 will be 1 of two possible text strings (eg text 1 or text 2)and the vaule in g2 will be 1 of 4 possible integers (eg 4,8,16,24) and I am trying to get the combination of x2 and g2 to output a values from a defined list

so if x2 = "text 1" and g2 = "24" then lookup/match to a list (i have tried using arrays, and can create them but cannot tap into using the stored values) and output an integer (possible results = 4 for each text strings)

Sorry if this is not clear but this explanation may indicate that I do not think logically enough to work out the vba..!

TIA

 

[VoG]

try like this

if range("x2").value = "text 1" and range("g2!).value = 24 Then

 

[andyandy12345]

Thanks, not quite getting it to work like you suggest jsut yet, is there a way to use the If condition1 and contion 2 to lookup/match a pedefined list or array?

 

[VoG]

Is G2 to be compared against a list? If so where is that list?

 

[andyandy12345]

both condtions in column x range and column g range need to be checked to determine result

range for column x will only contain "text 1" or "text 2"
range for column g will only contain numerical value 0,4,8,16 or 24

examples:

if x2 = "text 1" and g2 = 24 then result = 4

OR

if x2 = "text 2" and g2 = 24 then result = 5

Hope this explains...

Thank you

 

[VoG]

No it doesn't. What numerical value constitutes a match?

 

[andyandy12345]

the only inputs with desired results are:

column x coulmn g Result
text 1 0 0
text 1 4 1
text 1 8 2
text 1 16 3
text 1 24 4
text 2 0 0
text 2 4 1
text 2 8 3
text 2 16 4
text 2 24 5

 

[andyandy12345]

sorry that lost its format
under column x there are just text 1 or text 2
under column g there are just 0 0r 4 or 8 or 16 or 24

each of these possible 10 combinations will have the result under the result colum.