Want to be able to select data from Column C (3 data validations/drop down menus) and have the corresponding values display in the appropriate fields in column H.
Not sure if this is possible?
Want to be able to select data from Column C (3 data validations/drop down menus) and have the corresponding values display in the appropriate fields in column H.
Not sure if this is possible?
Got the solution..
Check the attachment..
was a bit tricky.. But I managed...
I have used array formula..
So use ctrl + shift + enter to enter the formula..
Don't use only enter..
Don't forget to click *
Hi and welcome to the forum
1st make sure that the headings in the table match the "headings in column G.
Then for H2, H4, and H8, use this REGULAR formula...
=INDEX($D$18:$R$28,MATCH($C$2&$C$4,INDEX($B$18:$B$28&$C$18:$C$28,0),0),MATCH(G2,$D$16:$R$16,0)+MATCH($C$6,$D$17:$G$17,0)-1)
For the others, use this REGULAR formula...
=INDEX($D$18:$R$28,MATCH($C$2&$C$4,INDEX($B$18:$B$28&$C$18:$C$28,0),0),MATCH(G6,$D$16:$R$16,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
Please find attached the updated file, I have used array formula here. Please press CTRL+SHIFT+ENTER to confirm.
Glad it worked for you and thanks for the feedback Thanks you you as well, Vikus
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks