show vaule of a cell in one sheet into an other

Nefe19

I'd like to have the value shown here

Show in this cell on this sheet.

I've tried a vlookup formula and a match lookup but can't seem to get them to work. Any ideas?

AravindGP

Hi @Nefe19

There are a few ways in which you can get the value in another sheet. The best approach depends on what you're trying achieve.

1. You can right click on the second sheet in test and click on "Link from Cell in Other sheet...". This will create a link and each time there's an update in sheet 1, it will reflect the value in sheet 2.
2. If there's a common look up value in both sheets, you can use Index/Match or Index/Collect (if there are multiple conditions) to pull the values.
3. If the values don't have to sync up in real time, you can use a copy workflow to copy the data from sheet 1 to sheet 2 on addition or change of data.