Dear Excel Gurus,
I'm struggling with simple task cause I'm apparently very stupid, so I'd desperately like to ask you to help me: I want to transfer value of function from Row to Column (E2 to B2; G2 to B3; I2 to B4... see attached picture). That's all. I'm also attaching corresponding Excel sheet. Thank you for your help, you could save my life!
Note: Simple function =(B2)=E2; (B3)=G2 won't help, cause I need to sort huge amount of data like that.
b2=IFERROR(INDEX($E$2:$M$3,MATCH(B$1,$D$2:$D$3,0),MATCH($A2,$E$1:$M$1,0)),"")
Copy and paste the above across B2:C6
OR Try below in B2
=IFERROR(VLOOKUP(B$1,$D$2:$M$3,MATCH($A2,$D$1:$M$1,0)),"")
Last edited by samba_ravi; 06-26-2019 at 03:13 AM.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
That's exactly what I was looking for! You're genious! Thank you for your quick response!!!
I've got further extension to this task: is there any formula for sorting of results placed in H2:P10 to C2:D11. For example result J7 (2,L1,B) would be automatically positioned in C8? Thank you very much for the help!Attachment 629767
Try pasting the following into cell C2 then drag the fill handle over and down:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks