Hi there,
I would like to populate a set of values from a table based on the variable selected in the drop down box. I have included a sample of my work in the attached excel file. In this file I would like to populate the size of my clients account based on a particular financial year selected in the drop down box in cell D2.
Thank you very much for your help.Sample file.xlsx
Try this, copied down...
=INDEX(RawData!$B$3:$E$12,MATCH(Input!$A5,RawData!$A$3:$A$12,0),MATCH(Input!$D$2,RawData!$B$2:$E$2,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
Thank you. That worked perfectly!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks