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
|