Excel Formula error?

[cicmic]

Hi guys. Im using the following formula..

=INDEX(IngredientRecipesPrep!$1:$1048576,MATCH(C$1,IngredientRecipesPrep!$1:$1,0),MATCH($A4,IngredientRecipesPrep!$A:$A,0))/VLOOKUP(C$1,DailyPrepParLevels!$1:$1048576,23,FALSE)*C$2

im trying to match up two values with =index to get a number then divide with another value then multiply with another... instead of getting the right number im getting results as if the formula was to transpose the cells downwards (the right numbers seem to appear but transposed..).. i dont understand why. Can you please take a look and try to see what I have done wrong? I am happy to send an attachment.. can find that option here.

 

[ukmikeb]

Hi

Does this -

Index(Array, Row Num, Column num)

help?

I think you're doing -
Index(Array, Column num, Row Num)

 

[hamonoakira]

Agree with ukmikeb

 

[ukmikeb]

Hi

If you cross-post on another forum please quote the link
http://www.excelforum.com/excel-gen...se-in-file-instead-of-normally-appearing.html
on this forum.

It could save members time taken to provide a solution on this forum when it has already been solved on the other forum.

Thank you.

 

[cicmic]

amazing!! thank you so much!!!

 

[ukmikeb]

Hi

Apologies for not welcoming you to this forum in the first post.

Pleased to have helped.

Thank you for the feedback.

Good luck with your project.