Forum Discussion
Excel Formula for database
May_ThuThu_Aung, it is a bit confusing but I think you will find the answer in the links that I will provide below. Please let me know if that solved your problem. If you still need help after that, please answer back sending a sample file and I'll try to help further.
video: https://www.youtube.com/watch?v=VxReJslyJm8 (see more information on the video description.)
Playlist with other examples: https://www.youtube.com/playlist?list=PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y
HI Celia_Alves
Hi, MS-Tech community,
Thank you for your reply.
Yes, what I mean a dropbox is a drop-down list.
I need to link with the drop-down list and formula. Is it formula working in drop-down lists?
Let me explain in brief, for example, I have 3 categories in 3 columns which are A, B, and C. When I type A1 in A column, I want to appear the data of A1 in B and C columns with drop-down lists because of the need to choose the data from that lists. Next, when I change A2 and then the A2 data would appear in those columns the same as above.
I'll prepare the data of A1 in another sheet to use for the drop-down list. Is it possible to link with drop-down function and formula? or which function/formula should I use for this data analysis. I need help to solve this.
Sorry for my explanation to make you confused. Excuse my English writing. I'm looking for your reply. Thank you so much.
May_ThuThu_Aung, it is a bit confusing but I think you will find the answer in the links that I will provide below. Please let me know if that solved your problem. If you still need help after that, please answer back sending a sample file and I'll try to help further.
video: https://www.youtube.com/watch?v=VxReJslyJm8 (see more information on the video description.)
Playlist with other examples: https://www.youtube.com/playlist?list=PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y
Celia_Alves Thank you so much for sharing the link. It is really helpful. After watching the video link, I was too close to the answer but still have errors. I would like to raise the errors which were found when I did according to the tutorial.
I've made with 2 separate sheets one is "References" and another one is named with "All Contact". In the references sheet, data under the blue table is for "District" and the black is for "Township". When I create drop-down lists and formulas its appears "#VALUE!" for some cells. I can't fix them and how to edit the formula. Except for these errors, all are looking OK so far.
Please kindly see the attached file. Thank you so much again.
I amended the file and all seems to be working now. You just need to complete a table with the table codes as explained in the tutorial attached.
I used a simpler formula for the names and the data validation.
I hope this helps! Good luck and let me know how it goes.
Hi Celia_Alves
Please accept my apology for the delayed reply because I was on-duty traveling start from this week until today. I've looked at the files of tutorial and database which you sent, they are very helpful for my database and I've learned new formula from you. And then, I completed the table as you explained, now I'm working on this but not yet found the error. I'll take time to fill the data if it is ok I'll start using for the entry process.
May I ask you one thing, how did you do this formula. I've tried this but not yet succeed.
Thank you very much again for your help Celia_Alves . Have a nice day.