Evening
After a full day of trying I've got down to two different formula but i'm having a problem with each one, Option 1 brings back 0's when there is no text in the cell Vlookup is searching, whilst Option 2 solves the 0's but then brings back #REF! when D2 on the "Control Sheet" is blank.
Just for information the Staff members name that I use in the D column (D2, D3 etc) is only added once a client is allocated, before which it is left blank
Any ideas how to get Option 1 below to stop showing 0's or how to get Option 2 below to stop showing #REF!
Option 1
=IF('Control Sheet'!D2<>"",VLOOKUP(A2,INDIRECT('Control Sheet'!D2&"!$A:$K"),11,0),"")
Options 2
=T(VLOOKUP(A2,INDIRECT("'"&'Control Sheet'!D2&"'!A:K"),11,0))
Bookmarks