Wow, so no one has any ideas on this in this forum? -Peter
K Ken Wright Nov 3, 2004 #2 Can't see you having asked that question?? In answer though, yes you can use INDEX/MATCH or OFFSET/MATCH as alternatives which will also get you round the problem of needing the lookup column to be on the left.
Can't see you having asked that question?? In answer though, yes you can use INDEX/MATCH or OFFSET/MATCH as alternatives which will also get you round the problem of needing the lookup column to be on the left.