H2: =IF(F2="A",IF(G2=1,"V1",IF(G2=2,"V3","")),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
...

I am trying to test the values of cells in two columns of data and
based on the contents of these values insert a value into a third
column.

For example:

If the value in Cell F2 = 'A' AND the value in Cell G2 = 1 THEN insert
the value 'V1' into Cell H2

If the value in Cell F2 = 'A' AND the value in Cell G2 = 2 THEN insert
the value 'V3' into Cell H2

etc.

Can anyone please help me with this?