in VB

If application.and(range("i6")="US",range("I10")="Tes t") then
Range("G25")="TestingUS"
Else
If application.and(range("i7")="UK",range("I10")="Tes t") then
Range("G25")="TestingUK"
End iF
End if

HTH

"SianH" wrote:


Hiya,

Thanks for the info - I did have that in place, when I was testing to see
whether I could get it to work. Problem is I have several values to check
for and several results to display, so I need to put this into VB and an
'elseif' statement. Any ideas?

Thanks again,

Sian

"Toppers" wrote:

in G25 put :

=IF(AND(I6="US",I10="Test"),"TestingUS","")

HTH

"SianH" wrote:

Hi all,

I wonder if someone can help ...

I'm constructing a statement that checks two cells for values, if those
values are as expected, then another cell should display a specific value.

i.e. :
If I6 = "US" And I10 = "Test" Then
G25 = "TestingUS"

I'd like the value to appear in the G25 cell (basically so I can use it for
other things).

I don't know that much about VB, hence why I'm getting stuck on how to get
it to actually insert the value into the G25 cell.

Any help would be greatly appreciated!

Thanks,

Sian