| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.  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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.  Lori-- LoriM1 ------------------------------------------------------------------------ LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815 View this thread: http://www.excelforum.com/showthread...hreadid=532681 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. Lori-- LoriM1 ------------------------------------------------------------------------ LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815 View this thread: http://www.excelforum.com/showthread...hreadid=532681 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement nightmare | Excel Discussion (Misc queries) | |||
Linear Mode
