index match match

TLDR - Create a VBA custom function (OurDataFx) replicating INDEX MATCH MATCH sourcing to another workbook which can be used in any Excel spreadsheet and you only need to set up MATCH lookup_value parameters in this OurDataFx because INDEX array and MATCH lookup_array are defined directly via...

Hello all, New to the thread so I do apologies if this isn't sufficient. I am trying to create VBA code for Index Match Match with a loop. I have attached an image to help. To detail the problem; - Cells A4:C13 have permutations from myarray (1,2,3,4,7) where I want 3 numbers picked and...

Hi, I have two-pronged question though the most important one will be the 1st bullet and the less important will be the 2nd bullet. The uploaded excel will show the same format for the aggregate data on the top and the different sets of data outlined in black below it. Unsure if sumifs and...

******** name="google_ads_iframe_/22152718/sws-hb//mrexcel.com//in_post_0" width="300" height="250" title="3rd party ad content" id="google_ads_iframe_/22152718/sws-hb//mrexcel.com//in_post_0" frameBorder="0" marginWidth="0" marginHeight="0" scrolling="no" style="border: 0px currentColor...

I need to index match match but the data i am trying to find is in a table like below. The cost of the units needed is always rounded down so in the Cost column for 2478 units i want the cost of 2000 units against code 4/1 therefore £773, can anyone help?? <colgroup><col width="64"...

I'm trying to look up values based on three criteria - my gut is that this needs to be an array formula but I'm beggared if I can get it to work. My source table looks as follows: Project Category 1 2 3 4 5 6 Project A Category A 9 4 3 6 0 2 Project A Category B 7...

Honestly, it's hard to believe a solution as easy as the one I'm asking for doesn't exist on the internet (spent 1h googling), but here it goes: Consider this table: Now, if we wanted to look up what a combination of R1 and C1 gives us, that would be a simple INDEX MATCH MATCH. But what if...

Hi, I have 2 spreadsheets. The first one has 2 columns Column 1 is a 'Task Number' Column 2 is a 'Product Number' On my other spreadsheet i have the Task numbers running in each column and the product numbers running down the rows to form a sort of empty table/matrix. How can i look up the...