Index Match not working

[Guest]

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.

 

[Guest]

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))

 

[Guest]

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.