Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Counting Function Dilemma | Excel Worksheet Functions |