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

=IF(B2=K2,A2,"")

I assume you want a blank in L if B and K are not the same?

--

David Biddulph

I assume you want a blank in L if B and K are not the same?

--

David Biddulph

With a formula...

Entered in L1 then copied down as needed:

=IF(B1=K1,A1,"")

--

Biff

Microsoft Excel MVP

Entered in L1 then copied down as needed:

=IF(B1=K1,A1,"")

--

Biff

Microsoft Excel MVP

This worked beautifully....Thank you so much.

--

jeannie v

--

jeannie v

You're welcome. Thanks for the feedback!

--

Biff

Microsoft Excel MVP

--

Biff

Microsoft Excel MVP

1. "Matching" column A's values in column B

2. Parent Columns and Child Columns don't have type-matching columns

3. Calculated Column using Lookup Column, Text Column and Me

4. Tabbing from column to column to column in a 5 column document.

5. Counting A's in a table column 1, F's in column 2, etc...

6. match row, then match column, then get header for that column?

7. Sum a column is criteria in two in column and other column are met

8. Referencing date column A & time column B to get info from column

9. locate a column, sum specific columns to the right of that column

10. select range in column, calculate on range plus 3 columns, output in range plus 7 columns

11. Sort column B but keep value in column A with value column B

12. Divide Column A by Column B multiply Column C

13. Can I SUM column C IF Column A=X AND Column D=Y?

14. Columns, columns, too many columns

15. Chart with One Column Column and Two Stacked Columns

5 post • Page:**1** of **1**