Thread: IF function
View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

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