Htykuut

I have a column with formulas(column I) which finds a specific cell in a tabel based on two cells(Columns G and H) and using LOOKUP and MATCH. All cells in the table have different formulas(tableFormulas) to get a value, but they are very similar and all have the same reference to another cell(A1), the reference is within an IF-function which checks if it equals 1.

I would like, if possible, to change the reference to A1 in the tableFormulas too refer to a cell in column J relative to the formulas in column I. So basically I would like to use one cell but change a reference depending on the cell collecting the data.

Here is an Example image of my problem since the whole thing is a bit bigger, more spread out and not in English.

I have looked for similar problems but found nothing, however I found out that maybe the functions INDIRECT or possibly CELL or ADDRESS could work. The only other way I can think of to do it is to have 27 tables ( yes thats how many cells/rows I have in columns G to J) but that requires much more work.

I hope this makes sense, cause I am not very good at explaining, so feel free to ask anything. I am very grateful for any help!

EDIT: I found a way too not having to duplicate and change every formula 27 times, but not the way I hoped. I just made 2 tables since the cell A1 or column J that I wanted to change reference, depending on the cell collecting the data, are just supposed to be 1 or 2. Then I could just use IF in the formulas in column I to check if the value in column J is either 1 or 2. However if anyone knows if it is possible to solve my original problem, that would be great since it makes it easier if the values in Column J could be more.