HELP! - Lookup tab based on cell value

[Froobage]

Hi All,

Any help with the following would be greatly appreciated

This is my current formula:

=IFERROR(INDEX('Devices'!$A$1:$V$999,SMALL(IF('Devices'!$D$1:$D$999='IOS Search'!$B$1,ROW('Devices'!$D$1:$D$999)),ROWS($1:1)),1),"")

However I want to replace 'Devices' with a cell value i.e. $C$1

Would anyone know how I could achieve this?

Thanks

-Froob

 

[ajamess]

I would use Indirect.

http://www.contextures.com/xlFunctions05.html