I have data in one format:

Jan Feb
CoA 10 20
CoB 30 40

I want to be able to do a lookup to get it to look like:
CoA CoB
Jan 10 30
Feb 20 40

I tried doing an index with embedded matches, but that didn't work -- Does
anyone have any suggestions?

I don't want to do a copy-paste values-transpose because it's going to be
something I'm going to need to update on a daily basis and want to be able to
trace back where my numbers are coming from.

Any help would be appreciated.

thx.

B6: holds CoA
A7: holds Jan


=INDEX($A$1:$C$3,MATCH(B$6,$A$1:$A$3,0),MATCH($A7, $A$1:$C$1,0))



"terri" wrote:

I have data in one format:

Jan Feb
CoA 10 20
CoB 30 40

I want to be able to do a lookup to get it to look like:
CoA CoB
Jan 10 30
Feb 20 40

I tried doing an index with embedded matches, but that didn't work -- Does
anyone have any suggestions?

I don't want to do a copy-paste values-transpose because it's going to be
something I'm going to need to update on a daily basis and want to be able to
trace back where my numbers are coming from.

Any help would be appreciated.

thx.

You totally rock!!! you have no idea how much time you've saved me.

I was only going index($b$2:$c$3,match.....

Can't thank you enough.

"Teethless mama" wrote:

B6: holds CoA
A7: holds Jan


=INDEX($A$1:$C$3,MATCH(B$6,$A$1:$A$3,0),MATCH($A7, $A$1:$C$1,0))



"terri" wrote:

I have data in one format:

Jan Feb
CoA 10 20
CoB 30 40

I want to be able to do a lookup to get it to look like:
CoA CoB
Jan 10 30
Feb 20 40

I tried doing an index with embedded matches, but that didn't work -- Does
anyone have any suggestions?

I don't want to do a copy-paste values-transpose because it's going to be
something I'm going to need to update on a daily basis and want to be able to
trace back where my numbers are coming from.

Any help would be appreciated.

thx.