Forum Discussion
Excel Formula for database
Hi,
I would like to know the formula name to link with dropbox and the "IF" function. For example, when I select a name from one cell I would like to appear the respective data of that name in another cell. Could you please show me how to link and which formula should I use for this data analysis. I'm looking for your reply. Thank you in advance.
Best regards,
MTTA
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
14 Replies
please help with this
Enter a database function in cell K18 to determine the total number of FT employees. To complete the function use the range A5:H25 as the database argument, cell E5 for the field, and the range K10:K11 for the criteria.
- Hi!
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
