IF function

J

Jaladino

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
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Simple calculation where values change to letters? 3
column to row draging 1
Conditional Formatting Formula 3
If, Or, and 5
Formula than understands midnight? 26
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2

Top