Please attached image. I am looking for the formula to use in Column "C" to get data from line item based on a dropdown menu input. I am using Google Sheets for this.
- Dave
Mystique Excel Formula.jpg
Please attached image. I am looking for the formula to use in Column "C" to get data from line item based on a dropdown menu input. I am using Google Sheets for this.
- Dave
Mystique Excel Formula.jpg
Last edited by barstone; 12-31-2018 at 11:24 AM. Reason: Adding Excel Attachment
Hi and welcome to the forum Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Picture are rarely much use an no one wants to recreae your data in order to test a solution.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thank you. Of course, sorry about that completely new to this forum. I have attached an Excel document. Please see above.
Hi Dave
Are you able to zip up the google sheets doc as well and upload, or point me to the file on a shared site?
here you go. Let me know if it works or not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks