On 10/8/2010 9:10 AM, Brad Rogers wrote:
On Fri, 08 Oct 2010 15:58:57 +0100
Mike Scott<[email protected]> wrote:
Hello Mike,
Is vlookup() of any help? It seems in the right sort of direction
It is indeed; I don't seem to be able to get that function to do a
lookup right to left, rather than left to right, but I've overcome that
by duplicating the numerical data on the left of the text, but in white
text on a white background, so it can't be read.
Many thanks for your help, Mike. I was tearing what little hair I have
left out, trying to figure this one.
You could have just hidden the column. FORMAT => COLUMN => HIDE.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
