Index Match not working

T

terri

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.
 
T

Teethless mama

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

terri

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.
 
Top