| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return text in Column A if Column B and Column K match
Greetings Experts:
I need help in doing what should be very simple...I would like a formula or a macro that will return the text from Column A and plant in Column L if Column B and Column K are the same. Example: B = 12345 K=12345 Text in Column A is entered in Column L Any help you can provide would be greatly appreciated. -- jeannie v |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return text in Column A if Column B and Column K match
=IF(B2=K2,A2,"")
I assume you want a blank in L if B and K are not the same? -- David Biddulph "jeannie v" wrote in message ... Greetings Experts: I need help in doing what should be very simple...I would like a formula or a macro that will return the text from Column A and plant in Column L if Column B and Column K are the same. Example: B = 12345 K=12345 Text in Column A is entered in Column L Any help you can provide would be greatly appreciated. -- jeannie v |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return text in Column A if Column B and Column K match
With a formula...
Entered in L1 then copied down as needed: =IF(B1=K1,A1,"") -- Biff Microsoft Excel MVP "jeannie v" wrote in message ... Greetings Experts: I need help in doing what should be very simple...I would like a formula or a macro that will return the text from Column A and plant in Column L if Column B and Column K are the same. Example: B = 12345 K=12345 Text in Column A is entered in Column L Any help you can provide would be greatly appreciated. -- jeannie v |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return text in Column A if Column B and Column K match
This worked beautifully....Thank you so much.
-- jeannie v "T. Valko" wrote: With a formula... Entered in L1 then copied down as needed: =IF(B1=K1,A1,"") -- Biff Microsoft Excel MVP "jeannie v" wrote in message ... Greetings Experts: I need help in doing what should be very simple...I would like a formula or a macro that will return the text from Column A and plant in Column L if Column B and Column K are the same. Example: B = 12345 K=12345 Text in Column A is entered in Column L Any help you can provide would be greatly appreciated. -- jeannie v |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return text in Column A if Column B and Column K match
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "jeannie v" wrote in message ... This worked beautifully....Thank you so much. -- jeannie v "T. Valko" wrote: With a formula... Entered in L1 then copied down as needed: =IF(B1=K1,A1,"") -- Biff Microsoft Excel MVP "jeannie v" wrote in message ... Greetings Experts: I need help in doing what should be very simple...I would like a formula or a macro that will return the text from Column A and plant in Column L if Column B and Column K are the same. Example: B = 12345 K=12345 Text in Column A is entered in Column L Any help you can provide would be greatly appreciated. -- jeannie v |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match a cell to something in a column and return a YES | Excel Worksheet Functions | |||
| Find max value in one column and return the value of corrosponding cell in different column | Excel Worksheet Functions | |||
| Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions | |||
| Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
Hybrid Mode
