A little LOOKUP poser I need some help on.
I have a number of columns with dates as the headers, and a list of information under each date
From another worksheet a cell (J43) will derive a number, (this is variable)
F4 = Date
F2:QT51 = the Array
??? = value of J43
How can I get the value of J43 into the above formula, if it is at all possible, or am I missing something that I cant see,
Don't worry guys, found the really simple answer of
I was putting in an = sign which was throwing me. Sorry to waste any ones time.
message edited by tonygibb