lookup 2 values

Hello, I have monthly sales data by item for 12 months. Some items do not have any sales data in every month. My raw data source omits these months and skips over them. However, I need to show these months/item as ZERO for that month. Some conditions that are always true: 1. For any month in...

I have a dataset shown below that is used for production scheduling. I would like to be able to look up by the bay number and the date and return the job # and the phase that the date falls in. If I reorganize the data, I can use an index match and concatenate function. However, the scheduler...

Hi All, Hopefully you can assist please as my VBA skills are unfortunately lacking in this area. I have a spreadsheet with 2 values in different columns, What i'm trying to do is... Where the value in column S is greater than the value in column F, i want to replace the column F value with...

Greetings, I am seeking an advice related to Microsoft excel 2010, My tables are shown in the kindly attached photo below, https://drive.google.com/file/d/1a7VOsvPDcHVPyDcdE6qzo-hGRuq67rII/view?usp=drivesdk What is needed, in Table_3, To populate column [AMOUNT] with values from Table_2...

Hello, I would like to write excel vba codes to help me find some values in an Excel table and do an interpolation between the values. I tried Bard, but I couldn't get it to understand what i need. Your help is very much appreciated. I have a lookup table like this: A B Result 180 29.2035...

Hi, all. I need your help, please. I have a range of numbers in 3 columns: Column A has groups of repeated numbers representing a quantity (e.g., 1 is listed 5 times, 50 is listed 5 times, 100 is listed 5 times etc.). Column B has 1, 4, 6, 8, 10 representing the number of ingredients...

Hi, I currently have this formula: =TEXTJOIN(",",,FILTER(TEXT(Daily_Data!$C$5:$C$5000,"dd/mm/yyyy"),Daily_Data!F5:F5000=LARGE(Daily_Data!F5:F5000,2)))&"." Now this works fine, in that it will return the dates for the highest number in column F. What I'm after is to have the value of...

Hi All, I need some help. I am trying to automate credit control function in a company. Amount of credit allowed to a customer depends on the length of relationship and will have different approval levels. However, Index and match isn't exactly helping with the situation. For example, if year is...

A friend of mine asked me if I could write something that would use the names on sheet two in column be to replace the names on sheet 1 in column a. The actual sheet has about 47K lines of data and will grow as the year grows. What is listed below is completely made up. I've looked at the...

Hi, I am stuck with an excel issue, where I need to look values based on

Hi, I am looking for some help in finding an excel formula which will look up to manual values against a table on another sheet and give me the number in return. For example, On sheet 1 I am looking search for the following values, Colleague name and period. Within the table on Sheet 2 i...

<tbody> Order Appple Orange Lemon None Null ProdType 1 Apple Apple 2 Apple None Null Apple 3 Apple Orange Multiple 4 None Null No ProdType 5 Lemon None Null Lemon 6 None No ProdType 7 Apple Orange Lemon None Null Multiple 8 Null No ProdType </tbody>...

Hi, I have two different data sources which gather information on users. One is a telephony recording system and the other is a CRM type system. I have generated CSV dumps from both systems. I would like to build a formula which would use a name and date/time from the CRM sheet and then find...

Requesting formula assistance for following: If 2 cells in Column D Match & Column C Match & Column B 'Date Time' is < 10 Minutes Result is corresponding value from Column A. To answer the question "What orders were done by same employee from the same Customer during the same Order call?"...

Hi, Hope some one can assist me with this. I am trying to do a HLOOKUP from data like below <tbody> 13/14 P13W3 13/14 P13W4 14/15 P1W1 14/15 P1W2 Bread 46 55 54 33 Rolls 28 22 42 12 Butter 66 57 58 69 </tbody> On another tab I have a drop down box to select the period/week...

Hello. I am trying to create a formula that will lookup a value from a table based on 2 criteria, but in certain cases I only want 1 criteria. The table would like this... In cells A1:A5 Blue Red Green * Black In cells B1:B5 Dog Fish Fish Fish Dog In cells C1:C5 Result1 Result2 Result3...

Probably the answer is very simple, but I couldn't find it anywhere. Here is the situation: I have a lot of sheets with different customers. I want to have an overview on one sheet with my customers and what they ordered. For example is want to know how much papaya I sold on 6th of June...

Hi All, I'll do my best to explain my issue. It's a similar problem to threads that I have seen resolved, but none seem to fit my problem... (I've included some context at the bottom of the post) Essentially, I need to perform a 3 (or 2) way lookup and return a result from a field on the data...

Hello, An urgent question and any help appreciated I am working with a model which uses two tables. The first one is historical (there is column Updated Date)and is updated every week. So lets say it is my fact table where I have many lookupvalue columns to look data from my other dimension...

Hello! I am trying to use a formula to first Search vertically within a column for "VALUE A", then search within the row of "VALUE A" for "VALUE B", then output "VALUE C" from row 1 of the column that "VALUE B" is located within. Here is a photo of what I would like: I have found something...