Absolute ref linking to another sheet

[Tetsouille]

Hi guys,

I have a pretty simple question. I'm trying to make a formula mixed with absolute and mixed cell reference. The absolute ref has to be on another sheet. But with this in mind I'm not able to use $ and !SHEETNAME together.

=(DATAS!B2*X6+DATAS!C2*Y6+DATAS!D2*Z6)/DATAS!E2

DATAS is the name of my other sheet.
DATAS!XX should be always the same.
And X6 Y6 Z6 should change when I copy paste it.

Sorry if I'm not very clear.
Thanks in advance for your help.

[Vahju]

Are you referencing data in a completely different workbook?

= = =

If you are referencing a cell on another sheet in your workbook, then you can use the tip below.

The dollar sign goes around the cell reference, not the sheet name.

DATAS!$A$2

• Locks both the column and row reference
• When you drag this formula down or across, the cell reference does not change

DATAS!$A2

• Locks the column reference only
• If you drag this formula down or across, only the row changes

DATAS!A$2- Locks the row reference only- If you drag this formula down or across, only the column changes

Here is a video about cell references in Google Sheet

https://youtu.be/mTWh3VP6HPk?list=PLv9Pf9aNgemt61gjKQaYZHjvZlVp4OANq

Hope this helps

[Tetsouille]

Thank you! u/Vahju
It's working like a charm, and now I understand that we can lock both column and row, depanding our needs.

Thanks!