IF Formula between 2 worksheets

Another Formula i cant seem to get to work with my limited knowledge! Where am i going wrong with this one?
I tried to use an IF formula that already exists and modify that to suit.Maybe that is completely incorrect?

I have a tab called drawers and the current cell in question is 22,8 (i have changed the columns to numbers for now.
This is the formula i thought might work going off the back of one of my previous, i have had to attach it as a word doc as this site keeps saying i have put a link in which isn't allowed?? (am i doing something wrong?)

This should read the word listed under type column 2 (cutting list) then it reads the numeric value in column 53 (cutting list) and display the result minus 12 back over on the drawers tab

Hope this makes sense?

Originally Posted by FDibbins

Nope, not at all. It is often hard enough to make out what a member is trying to ask, without having to decipher some unknown column numbering system that they have dreamed up.

Excel uses letter for column and numbers for rows - stick with that format, it's something we all understand and can easily work with...I have no clue what 22,8 means or where it supposed to be found (I can see no reference to 22 - and I guess row? 5)

Tell us where the formula is supposed to ,e, show us what you expect and - if necessary - explain how you arrive at that.

Hello thank you for your response, I just turned on the R1C1 reference style in options under formulas, but i understand how it can be difficult. i agree it isn't something i had seen before but at the time it made it easier for me. So i have switched it back and i will try to add more details.

So what i am trying to achieve is as follows.

Drawers tab - Sum destination Column V
IF Column B (Cutting List Tab) = Drawers, then Column V (Drawers Tab) = Column BA-12 (from the Cutting list tab)

the Answer in Cell V8 should be 550.

Hopefully that makes more sense now?

Kind Regards

Warren

This seems to work, thank you once again. I will discuss this with my colleague so far and see where they want to take it.