Accessing variables in VBA via formulas from the spreadsheet (assigned by VBA)

So in its most basic form I'm trying to do this:

Please Login or Register  to view this content.

Where i, j, and k are loops going through the different column values. (this is easier to read than the below)

I've also tried:

Please Login or Register  to view this content.

Either way gives me a 424 error code - Object required.

How do I properly access the cell values with the defined column and variable row?

Thanks!

Ah, that was definitely one of my problems. Now I'm getting a 1004 error - application defined or object defined error - still a problem with how I'm trying to access these cells.

That did solve the error - thanks!

This would be an example of one instance -

"=IF(AE3=AD3 & AC3=AA3, AB3+AF3,"")"
So yes I am using the &, so that both AE3=AD3 and AC3=AA3 have to be true in order for the cell to take the value (AB3+AF3).

I think you're right in that being the problem as I just set them both to be true, but got back a False answer.

Is there a way for Excel to accept two logical tests? I suppose I could do each one, output a 1 or 0 to two additional columns, then compare them?

Ah wow, well that was probably a huge part of the problem that shouldn't have been *palm to face*. Thanks!

The function is showing up now, but not how I intended. I'll *TRY* to explain my larger problem - with fear that it will scare you away!

Attached is an example of the data I'm using (I left them starting at column AA) - below is the code I am trying to use to get the desired effect.

But first - the two columns AC and AD are my "translation" list - think of it as if you were trying to convert spanish to english. (el or la = the, etc. - it isn't necessarily a one to one exchange). The list D_master_keys is the "language" I want to get it to, and D_LP_keys is the "language" I'm translating.

Anyway, for each D_LP_key I want to translate it to the D_Master_key - then add the values associated with them.
I tried doing this with dictionaries, as that's what they originally were, but to no avail. Here is that thread.

Please Login or Register  to view this content.

If you have any guidance on direction that might be helpful, it would be appreciated. Thanks for all your help so far!