Solved Find a column, then a specific cell in the column

September 13, 2013 at 08:29:24
Specs: Windows 7
Hi there,
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)

=IF(F4>DASHBOARD!R1,0,HLOOKUP(F4,PLACES!F2:QT51,???,FALSE))

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,
Please help.
Tony

Don't worry guys, found the really simple answer of

=IF(F4>DASHBOARD!R1,0,HLOOKUP(F4,PLACES!F2:QT51,J43,FALSE))

I was putting in an = sign which was throwing me. Sorry to waste any ones time.

message edited by tonygibb


See More: Find a column, then a specific cell in the column

Report •


#1
September 13, 2013 at 08:36:31
✔ Best Answer
Maybe it's me that's missing something.

Why wouldn't you simply put J43 in the formula?

=IF(F4>DASHBOARD!R1,0,HLOOKUP(F4,PLACES!F2:QT51,J43,FALSE))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 13, 2013 at 08:39:32
Hi there DerbyDad03, sorry to waste your time on this, s you rightly state just put in J43, I was using the = sign which was throwing me.
Thanks for the quick response though, very impressive

Report •

Related Solutions


Ask Question