LookUp and Match Question
Say that your output headers are in K1:N1 (K1 contains "Date"). Thus
K2 will contain 20071217. In L2:
=VLOOKUP(K2,$A$1:$D$6,MATCH(L$1,$A$1:$D$1,0),0)
HTH
Kostis Vezerides
On Dec 21, 7:56 pm, carl wrote:
My Data Table is 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 am trying to find a formula for B2:D2 below that will produce this
result..
Date GOOG DELL IBM
20071217 4.37% 0.80% NotFound
Thank YOu in Advance
|