Hi all,
I apologise if this topic has been covered previously. I have looked and not found anything, and I am nearly at my wit's end.
What I am attempting to do is perform a lookup based on an input value, and then return certain columns if the lookup is true.
For example, in my data source let's say I have columns A through Z, all populated. I would like to have a sheet where I can say if A1 matches "textstring", give me C1, H1, etc. There are in excess of 9000 rows that this has to be performed on.
I know enough that this is something to do with array / CSE formulae / vlookup, but I don't know how to fix it.
Any suggestions would be greatly appreciated . . . by myself and my boss.
Thanks,
Trevor
I apologise if this topic has been covered previously. I have looked and not found anything, and I am nearly at my wit's end.
What I am attempting to do is perform a lookup based on an input value, and then return certain columns if the lookup is true.
For example, in my data source let's say I have columns A through Z, all populated. I would like to have a sheet where I can say if A1 matches "textstring", give me C1, H1, etc. There are in excess of 9000 rows that this has to be performed on.
I know enough that this is something to do with array / CSE formulae / vlookup, but I don't know how to fix it.
Any suggestions would be greatly appreciated . . . by myself and my boss.
Thanks,
Trevor