tell me the best way to assign data from a table to another in excel?

June 18, 2022 / 1 minute of reading

You no need to transpose your data. Try below INDEX()/MATCH() combination.

=INDEX($F$2:$H$3,MATCH(B2,$E$2:$E$3,0),MATCH(A2,$F$1:$H$1,0))

enter image description here

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top