Find a Formula to retrieve big data to add in a different column

**minayat** · 03-15-2019, 02:40 PM

Hi Guys,

I would really appreciate if you could make my life easier for this project.
I want to find the original dates based on the location (Column A) and the amount (Column H) that match the data in the 2nd tab. Please see attached file .

For example, I have to filter greater than 3k and then manually type the location # to find the data (2nd tab) such as posted date ( Column L) that belongs to (Column B, 1st tab), description (Column H) belongs to Column F, 1st tab) ect... same for reference, Doc# all the blank item in tab 1.

Thank you so much guys.

**Melvosh** · 03-15-2019, 03:48 PM

You have multiple rows that return based on location and amount. Location 1036, amount -3407.02 returns 2 rows on the "7700961" tab. Is there another criteria to determine which row you want data from?

**ChemistB** · 03-15-2019, 03:52 PM

With data in A1:A12, Use this arrayed formula

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.