apples

I have a lookup table of this format: <tbody> A B C 1 Apples, Pears, Watermelons Green 123 2 Apples Red 456 </tbody> I need the data represented in the target table as below. Column A can contain multiple values that will appear as separate row names in the target table. Column B will...

Hello, I am trying to use INDEX/MATCH with LEFT, to change the returned value. Example: <tbody> Data1 Data2 5 Apples {are great}<are good=""></are> 10 Oranges {are also great}<are also="" good=""></are> </tbody> =INDEX(B:B,MATCH(5,A:A,0)) This Formula returns the value of Apples...

Hi, I have two tables, one with "source" data as follows: <tbody> A B C D E F G H I J K Lookup Helper High Low Geo_Lookup Geo_High Geo_Low Other Class Description Important A1 A1 11 Apples & Oranges N A2 #ALT 2 Apples & Pears N A2 55 High Apples & Pears Y A2...

I am trying to use a formula similar to match index that will allow me to index based like/similar words in cell. I want the result in Table 2. Table 2 does contain the exact words in Table 1, fruit column I am unable to use index to bring over the totals to Table 2 <colgroup><col><col...

Hello everyone, I would like to copy values from Sheet A to Sheet B. Sheet A has a drop-down (data validation list) and items in that sheet change according to the item that is selected. E.g.: Items in the drop-down are Apples, Oranges, Bananas. Below the drop-down I have monthly counts...

Is there a way for the combo box to show the last item that was selected? if they choose Apples then submitted their data can Apples then show up in that combo box next?

Hi, I am trying to separate comma separated text in multiple cells in a column but would like to retain the exact same date for each row of separated text except for Quantity and the transposed references. Also I will have varied rows of data in the reference column, Can some one help with this...

Hello! I am very new to VBA, and my stumbling block is this. I have three workbooks. Although they have other columns, the columns they have in common are apples, oranges, and grapes, and they are not in the same order in each of the workbooks. Is it possible to copy the information in apples...