Index Match question.... trying to use single value instead of array for index part

RJ_CCI

New Member
Joined
Jul 20, 2021
Messages
7
The top image is the driver page which has the lease number, the payment amount, and the dates that every payment gets made (monthly). I am trying to make a payment calendar where it shows for every lease the payment that day if there was one. I got it to work by doing an index match, but in order to do that I had to insert a row on the driver page underneath every lease with a payment for the corresponding date, in which case i just absolute referenced pmt amount and dragged it across. But i am sure there is a way that I can do this where I don't need to do that. I tried to do an index match where in the first part it asks for an array , i just absolute referenced the payment amount (not an array like the function calls for), and then matched the date row on the driver page to the singular date on the calendar, and it works for the first payment but then says #ref for every date the payment is supposed to hit after. Again, i bypassed this issue by putting an array of payments below every lease by I don't want to have to do that so I can just drag all the way down.

Thank you to anybody and everybody for all efforts in helping address this question!

Ryan



1631106387548.png


1631106412550.png
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
77,704
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,176,096
Messages
5,901,375
Members
434,887
Latest member
zoath

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top