Hlookup divided by Vlookup (Game levelling optimisation) [Google Sheets]

Hi All, crossposted: https://www.msofficeforums.com/excel/

Novice here.

Looking for support with a sheet I'm trying to build related to a game. The issue is dividing a Hlookup by a Vlookup. It works in a single sell but when I use an array to fill for multiple columns it pulls in the same answer for 4 cells and then the second answer for four cells. Every cell should be different, formulas and my thinking below.

two tables:
The first, includes horizontal data of player levels listed 1-99, left to right,
The second row, under this, is the experience required to complete that level. e.g. 500 1,324 2,560 4,208 6,268 8,740 11,624 14,920 18,628 22,748 for the first 10 levels.

The Second table: Has a vertical list of all craft able recipes in the game in the first column: e.g. Wood Boards,
The second column has the experience generated at level 1: 720.00,

This table then runs left to right with each level, as the recipes experience provided reduces from 100%, when you gain the recipe at the specific level, to 75% after +4 player levels, 50% at +8 player levels etc. e.g. 720.00 720.00 720.00 720.00 540.00 540.00 540.00 540.00 360.00 360.00

I am trying to build a summary table, using Hlookup to pull the total experience needed for a level /divided by Vlookup to pull the experience given by that recipe at that level.

My formula =HLOOKUP(N217,$N$3:$DH$5,2,FALSE)/VLOOKUP(C219,$C$9:$DH$214,12,FALSE) works for a single cell. But I want to copy this across for levels 1-99 and down for every recipe.


HLOOKUP:
N217 = level 1-99 in summary table
$N$3:$DH$5 = Table of levels and experience required
2 = The experience for the level

VLOOKUP:
C218 = name of recipe
$C$9:$DH$214 = Table of recipes and decreasing experience for each level
12 = Experience given for level 1 for all recipes


When I add an array, as below, the same answer is generated for the first four levels and then the next four levels e.g. 0.7 0.7 0.7 0.7 0.9 0.9 0.9 0.9 1.4 1.4

Instead of increasing in the number as the level experience required increased and experience gains from recipe decreases. It should look like. 0.7 1.8 3.6 5.8 11.6 16.2 21.5 27.6 51.7 63.2

Can someone flag what is wrong with the below causing this initial repetition?

=ArrayFormula(HLOOKUP(N217,$N$3:$DH$5,3,FALSE)/VLOOKUP(C219,$C$9:$DH$214,{12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110},FALSE))

Rule 7: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.

24 hours. Perhaps you can visit our Commercial Services and pay for support. Sometime that works. Weekend may be tough as lower volumes or participants.