LookUp/Match/Index/OffSet Question
Thank Teethless.
I could not get it to work. Formula returned "ref"
Can I send you a workbook ?
"Teethless mama" wrote:
Use the one I provided to you yesterday. It should work exactly what you are
asking for.
"carl" wrote:
Not sure what to do on this one. I posted yesterday.
My Data Table is set-up like this:
Date AA GOOG DELL
20071212 0.99% 3.89% 1.32%
20071213 0.48% 2.96% 0.46%
20071214 1.02% 2.25% 1.37%
20071217 0.76% 4.37% 0.80%
20071218 0.73% 5.00% 0.52%
I need to create another table that has the date in ColA and the Stocks
(AA,GOOG etc) in B1:D1. I need a formula that will be in B2:D3 that gives
this result..
Date AA BAC DELL
20071212 0.99% NotFound 1.32%
20071217 0.76% NotFound 0.80%
Thank You in advance
|