Changing Rows into Columns
Hi, thats correct i have a lot of data scattered across columns & rows, i
want to use a vlookup on another sheet to return these values.
"Gizmo63" wrote:
Judging by your posts what I guess you're trying to achieve is a check to see
if a particular value exists in your matrix.
This is the only reason I can see for creating a vlookup on 1 column only.
Can you confirm? If I'm right I can give you an answer.
Giz
"MartinW" wrote:
Ok Gary now I can understand your problem, unfortunately, I can't help you
other than to say I think it should be able to be done. Hopefully it won't
be long before one of the resident Gurus drops by and enlightens us both.
Cheers
Martin
|