If Statement???
 

~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


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

In Cell B22

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"LoriM1" wrote in
message ...

~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


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile:
http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

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



"LoriM1" wrote:


~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


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

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 ;)


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

=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)

"LoriM1" wrote in
message ...

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 ;)


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile:
http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

I cannot thank you enough!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

:) :) :) :) :) :) :) :) :) :)

Lori


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

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


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

=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)

"LoriM1" wrote in
message ...

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


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile:
http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

Thanks so much, Bob. I wasn't even close.

Lori


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

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.


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

=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)

"LoriM1" wrote in
message ...

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.


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile:
http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681

If Statement???
 

Thanks again for all of your help!
Lori


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681