Can't seem to get this one to work, getting #NA error
=HLOOKUP(L$1&M1&C$10:K$10,Data!$A$1:$V$8,4,FALSE)
I have a combo box on my worksheet that, when an option is selected is entering the appropriate index to cells L1 (Division) and M1 (Date (4/1/2011). I am trying to get this to lookup those 2 pieces of data in worksheet "Data" along with dates in the range C10:K10 (i.e. 4/27/2011) in the table_array of A1:V8 and return the value in row 4.
New to the HLOOKUP so I'm sure it's something simple.
I can provide a sample of my worksheet if necessary, couldn't find a place to upload a file here though.
Thanks for any help you could provide with this.
=HLOOKUP(L$1&M1&C$10:K$10,Data!$A$1:$V$8,4,FALSE)
I have a combo box on my worksheet that, when an option is selected is entering the appropriate index to cells L1 (Division) and M1 (Date (4/1/2011). I am trying to get this to lookup those 2 pieces of data in worksheet "Data" along with dates in the range C10:K10 (i.e. 4/27/2011) in the table_array of A1:V8 and return the value in row 4.
New to the HLOOKUP so I'm sure it's something simple.
I can provide a sample of my worksheet if necessary, couldn't find a place to upload a file here though.
Thanks for any help you could provide with this.
