Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 13th 07, 08:04 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 127
Default 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   Report Post  
Old December 13th 07, 08:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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   Report Post  
Old December 13th 07, 08:16 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default 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   Report Post  
Old December 13th 07, 08:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 127
Default 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   Report Post  
Old December 13th 07, 08:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match a cell to something in a column and return a YES Kathy Excel Worksheet Functions 1 October 26th 07 11:15 PM
Find max value in one column and return the value of corrosponding cell in different column [email protected] Excel Worksheet Functions 5 October 16th 07 12:33 PM
Index? Match? Function to sort and return value fr diff column in Smurfette Excel Worksheet Functions 6 April 27th 06 05:46 PM
Display missing Part Number if Column A does not match column B Erik T Excel Worksheet Functions 2 April 17th 06 11:23 PM
Need rows in Column A removed if they fully or partially match with any Column B row [email protected] Excel Discussion (Misc queries) 1 August 21st 05 11:41 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017