Google sheets: Function to return a value from another tab/cell

Hi guys,

I am seeking help with retrieving a value whilst INDEX/MATCHING data between 2 tabs.

My sheet has:

A name on the left (Admin Snapshot tab, cell A2). On this tab, I am looking to populate data in cells E2 and F2. The number I need is on the WC & DS Breakdown tabs, cells F6 and G6 (0 and 0). I am in need of an index/match function if possible please.

thank you guys!

https://docs.google.com/spreadsheets...it?usp=sharing

Due to the merged cells, you'll just need to add 4 to the match value when you pass it to the index function(s).

Hi Rory,

Not sure i follow. I have attempted this:

=INDEX('WC & DS breakdown'!F:F, MATCH(A2, 'WC & DS breakdown'!A:A,4))

I don't think that's what Rory meant. Try this:

=INDEX('WC & DS breakdown'!F:F, MATCH(A2, 'WC & DS breakdown'!A:A,0)+4)

got it thanks Ali!