Bring back rents per location from data table

Originally Posted by :) Sixthsense :)

In A6 Cell of Retrieved data Sheet - Array Formula - Requires CTRL+SHIFT+ENTER

=IFERROR(INDEX('Data Set'!$A$5:$D$32,SMALL(IF('Data Set'!$A$5:$A$32=$C$3,ROW('Data Set'!$A$5:$A$32)-MIN(ROW('Data Set'!$A$5:$A$32))+1),ROW($A1)),COLUMN(A$1)),"")

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

Drag it down and right...

Hello Mr Sixthsense,

Thank you for the reply. I've copied this formula into the retrieved dataset as instructed and it is only bringing back data in the 1 row.

I have enclosed a copy of the updated attachment. Where am i going wrong?

Thanks once again for your help.
Mr_V