If Statement???

L

LoriM1

~Oh gods of formulas, please help me!!! Can you help me with this
formula?~
If a cell in column a equals a cell in column f then insert in
column b the number in column g.
To Clarify:
The number in a22 is equal to the number in f400. The number
in
g400 needs to be placed in b22.

Please make it in Lori language. :confused:

Thank you!!!!!!!!!
Lori
 
B

Bob Phillips

In Cell B22

=IF(A22=F400,G400,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

CLR

In B22 put this formula............

=IF(A22=F400,G400,"")

The "" means if the condition does not exist, then just leave the cell
blank........you could change it to

=IF(A22=F400,G400,"They are not equal")

Vaya con Dios,
Chuck, CABGx3
 
L

LoriM1

Thank you both for your help but I forgot one little thing. I don't
know which cell it's in in column f. Both columns are a few thousand
lines long. I need it to find it then put the number from g in b. I'm
trying to save time by not cutting and pasting which may lead to errors.


One more little thing. Is there a formula for column f that will
highlight a cell in that column that found no match in column a? Both
columns don't have the exact same number of lines.

I really appreciate the help. I have a boss rushing me that has NO
CLUE.

Lori ;)
 
B

Bob Phillips

=INDEX(G:G,MATCH(A22,F:F,0)

Use conditional formatting with a formula of

=COUNTIF(A:A,F1)=0


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
L

LoriM1

One more quick question. When using the index and match formula you
gave me:

=INDEX(G:G,MATCH(A22,F:F,0)

How do I add if F is not blank?

Thanks again for your help.
:rolleyes: Lori
 
B

Bob Phillips

=IF(ISNA(MATCH(A22,F:F,0)),"",INDEX(G:G,MATCH(A22,F:F,0)))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
L

LoriM1

Ok, now my problem reversed itself. I guess I need if F and A are not
blank. I have a blank field in F and now every blank field in A fills
in B with the first corresponding number in G that F shows as blank.
 
B

Bob Phillips

=IF(OR(A22="",ISNA(MATCH(A22,F:F,0))),"",INDEX(G:G,MATCH(A22,F:F,0)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top