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
It is not clear what you need. Can you please explain in more detail?
It looks like VLOOKUP or XLOOKUP might be the formula you need.
What do you mean by Dropbox? Are you referring to a dropdown list?
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.
