Requesting Formula for matching 2 Cells

Dear all, i have attached 1 excel sheet in attachment, here if f2 cell and M2:M338929 columns are same values means then K & L columns should match with i2 & j2 cell value and give the output as colored in yellow and red color, i am requesting formula for entire columns, can you please help me out

Use INDEX MATCH, as you have been shown before.

If you want help, provide a sample dataset of NO MORE than 30 rows of data.

INDEX MATCH was covered in this thread: https://www.excelforum.com/excel-new...sheet-1-a.html

Try it yourself first, please.

1. Please submit a file with MAXIMUM 25 rows, not 20,000+++.

2. Please explain the expected results in red in your file.

Provide a sample dataset of NO MORE than 25-30 rows in TOTAL.

Please try in K2 and copy down:

Formula:

Please Login or Register  to view this content.

and in L2 and copy down:

Formula:

Please Login or Register  to view this content.

Originally Posted by maddyrafi1987

I have attached sample file mam as requested

The source data is still 1000s of rows - you have been told MANY times before to provide sample data of no more than 25-30 rows - this includes the SOURCE data. There should be NOTHING below row 31 in your sample worksheet.

Luckily for you, Hans has stepped in because I was just about to lock the thread until you complied fully with my request.

In future, if you provide massive datasets, your threads will be locked until you provide small ones.

Hans has told you: copy down. You have been receiving help here for long enough to know the basics of formula manipulation.

Please respond to post #9.

You are Welcome. Thanks for the feedback and glad to have helped. .

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.