IF function
 

What I want:
if cell A1 is same as F1 then B1 should becme same as G1 and C1 should
become H1. And if A1 is same as F2 than B1 should be same as H2 and C1 same
as G2... and so on

I have a list of 3 columns (F,G, and H) and 60 rows

Assuming your "H2" and "G2" reversal is a typo, put this in B1
=VLOOKUP(A1,F:H,2,FALSE)
and this in C1
=VLOOKUP(A1,F:H,3,FALSE)


Vaya con Dios,
Chuck, CABGx3


"Jaladino" wrote in message
...
What I want:
if cell A1 is same as F1 then B1 should becme same as G1 and C1 should
become H1. And if A1 is same as F2 than B1 should be same as H2 and C1
same
as G2... and so on

I have a list of 3 columns (F,G, and H) and 60 rows