Return text in Column A if Column B and Column K match

  • Thread starter Thread starter jeannie v
  • Start date Start date
J

jeannie v

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.
 
=IF(B2=K2,A2,"")
I assume you want a blank in L if B and K are not the same?
 
With a formula...

Entered in L1 then copied down as needed:

=IF(B1=K1,A1,"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare 2 lists and return value 2
With F1 value, look at A, if match or partial match return B 5
Match 2 columns + corresponding date? 1
Hide columns based on row values 2
Sum based upon matching data in different columns 1
Keep lines when one column equals certain criteria 2
Matching column criteria in a one to many relationship 8
Copy corresponding cell in Column B if cell in A contains certain text? 1

Back
Top