fruit

  1. M

    Switch

    I'm trying to learn some new formulas & have come across SWITCH. I know how to use VLOOKUPS I have a list of names of Fruit in Column A - in A1:A5 & a list of costs for each next to them in B1:B5 In D1 I want to type some fruit e.g. Apple, which is also in A3, the press Enter when I have...
  2. T

    Copy data on sheet2 to sheet1 base on column data.

    Please help me out. I want a vba that can automate this process that copy sheet2 to sheet1. For example on sheet2. Column D4 fruit column separate by a blank line with a new fruit with dates, purchase orders and quantity. There's six types of fruit that I need to keep track. What I want to do...
  3. P

    Horizontal and Vertical Lookup with date possible?

    I am wrecking my brain over what formula to use to summarize data (into a chart) using the data tab. Below on the Summary tab I would like to know how many Fruit, total AND individual, do I want and how many I've purchased for each date. As time passes, I will change the date in Row 2 and I...
  4. K

    Return multiple lookup results in different cells

    Hello, I'm trying to essentially do something similar to a vlookup, but instead of it just returning a single result, I want to see all results. I would like to have each result show in a different column. Here's what I have in mind: Basic Data Set <colgroup><col width="64" span="2"...
  5. P

    Index match vlookup

    Please help, I’m trying to accomplish the same result in this table with a formula when looking for thousands of data. Year Fruit Jan Feb March 2018 Banana. 1. 2. 3 2019 Banana 2. 3. 1 2018 Apple 4. 4. 4 2019 Apple. 2. 5. 3 Thanks
  6. D

    Automatic Dependable Generation - Fruit Case

    Hi all, I am trying to figure out if there is a possibility to find a solution to the following example: Let’s say that we have a table with input data including words and numbers. In that case that I need is for following up engineering cases. The problem is when you added a new case and it...
  7. G

    using SMALL, INDEX, with IF conditional adding a HYPERLINK

    I'm wondering if anyone can help me with working out how to add a hyperlink based on certain conditions. I have two worksheets - Worksheet "Catalogue" has a dropdown list to select which fruit and another worksheet which has information about the piece of fruit selected. There are multiple...
  8. A

    VBA Find Column Based on 2 Headers

    Hi All, I can't figure out how to word this to search properly, so I haven't found something even though I'm sure someone's posted this before... I'm in the process of converting a list to a grid, based on the values in the grid. I've done this before matching 1 criteria, but having trouble...
  9. C

    Copy and Paste to another sheet on an empty cell

    hi guys, new to the forum.... im trying to code up in VBA but stuck at the moment hoping to find answers... basically i have this worksheet tab call "Fruits", with a column header starting at cell A4 call "Fruit Types", and subsequently A5, A6 onwards have different names of fruits. Basically I...
  10. P

    VBA Excel Search every cell value from one column in another column and return output in desire columns

    Dear All, Kindly help me to solve below mention problem. In column A- master code from A2 to A In column B- master code of fruit from B2 to B In column C - list of fruits based on user entry Procedure - Search column B name in column C, if name of that fruit present in column C then copy name...
  11. S

    Why do I get this VBA error message?

    I have a table ("Fruit") in sheet "Fruit" which is comprised of the header (row 1) and then a single row in the body. The columns are: Apples Bananas Total Fruit I have no data in row 1, it is simply blank. If I input the following code into a vba module, it works fine. Sub Fruit() Dim...
  12. E

    Combining 2 columns usiing wildcards and using concatenate from 2 other columns

    Hello, To simplify what I am trying to do is: If column a = fruit column b = banana/s OR peach/es then concate columns c and d. I have done it by testing FRUIT and BANANA/S as below but I don't know how to also look for PEACH/ES as well to both return true...
  13. W

    Dropdown list with a group.

    Hi All Been a while but I'm stumped. I have a large list of data with a dropdown list that filters out what I need. Only issue is I would like to group a few options preferable using one list. My Example List Apple Banana Orange Cat Dog Mouse Fruit Animal Trick I would like to know how to...
  14. A

    Stumped Again

    I can do a join/transpose with one column but nothing I have tried will do a join/transpose with the condition being in two columns. Below is a sample of what I am trying to do. Thanks for any help you may give. <colgroup><col width="65" span="4" style="width: 65pt;"></colgroup><tbody>...
  15. R

    Can I make this Multi-Criteria Index-Match give me the next result if it's already found one?

    Using the formula here: https://exceljet.net/formula/index-and-match-with-multiple-criteria I have an index-match setup with about 5 or 6 different criteria. for simplicity sake, let's say there are only two criteria <tbody> A B C D E 1 FRUIT SIZE PRICE 2 BANANA 10 £6.50 3...
  16. C

    Best way to set-up this form

    I am trying to create a form in excel. With certain questions the user can select multiple options. For instance: What type of fruit would you like? (I used an active x combo box for this) No Fruit Apples Oranges Pears Grapes I want the user to be able to pick multiple options at once...
  17. M

    Lookup Function To Return Entire Table

    Hi first time posting here, any help is much appreciated. I'm trying to create a drop down list to reorder items, the drop down selection would return 3 columns and 25+ rows from a hidden sheet. I can create the drop down, and am familiar with a vlookup but cannot get a return on the multiple...
  18. masud8956

    SUM function with LOOKUP to a Dynamic List

    Hi all, I am having some trouble summing up some data from the dynamic range B2:C15. All the fruit names that populate $B$2:$B$15 belong to to either of the 4 groups. These 4 groups are also dynamic lists. They are: Group1: Range $E$3:$E$15, Group2: Range $F$3:$F$15, Group3: Range...
  19. S

    Macro to Create Table

    Hi all, Please help! I need a macro that does the following: User will input the information in the table below. User will then click a button tied to the macro. The macro will return the filled out table in a newly created sheet. For the table created by the macro, the cells will need to...
  20. B

    Summing area of data across multiple tabs with multiple criteria-array and indirect?

    Full disclosure this is a cross-forum thread (excelgure.ca) since I need to find a solution quickly! https://www.excelguru.ca/forums/showthread.php?9263-Summing-area-of-data-across-multiple-tabs-with-multiple-criteria-array-and-indirect Hi Everyone, I'm spinning my wheels here between index...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top