multiple lookups

Hello to all! Sure this maybe a bit billy bob basic for some, but I have some handy excel skills but come across a situation that I can't seem to work out. I'm not specifically looking for an answer, I am happy to play around and post an answer when I have found it, just maybe need a pointer or...

I have a table with three criteria. Two criteria are stated in columns, and one in a row. The table looks like this: I want to find a value which matches the three criteria. For example: I want the value for 'Cembrit Cetris Basic' , SC1 and Permanent. Then a value of 0.3 (cell C3) should be...

I have tried variations of index matches with if statements and SUMPRODUCT with multiple arrays all ending in errors. Can someone please help? I need to SUM the Value Column in the Source Table by matching the COMPANY NAME, PURCH TYPE, AND CATEGORY. In the example below the correct results...

So this is only some test data to prove the concept. Essentially I have a data set that will contain duplicated values in one column which I need to do a look up on with either blank cells or a unique identifier in another column. If the desire look up value is present in the first column, I...

Please help I have a spreadsheet that manages queries on a daily basis, each entry is time managed by a userform (ie timer starts when form opened and stops when closed) the start, stop and elapsed time get input on the log. This log is used by several people daily. the formula i have at the...

Hello Ladies and Gents, I am trying to create an automatically filled text box based on the text value of two other cells. Please see the example below. I have on another sheet two drop down lists, one to select the customer, the second recognises which customer has been selected and then...

<tbody> Formation Scored Conceeded Home / Away Result Points 4-4-2 4 2 H W 3 3-5-2 2 2 H D 1 4-3-3 0 1 A L 0 4-4-2 1 1 A D 1 </tbody> <tbody> Formation Total Conceeded Total Scored #W #D #L Total Points 4-4-2 ? ? ? ? ? ? </tbody> Based on the table above does anybody...

Hey everyone! I am having some trouble with my last column. I have in my worksheet 6 columns (a-f). Column A is simple a list of names. Column B is a start date. Column C is an end date. Column D is the # of hours between column b and c, excluding weekends and holidays. Column E is the date...

Hello All, This may have a fairly easy solution but I am an intermediate Excel user so I am not fully versed in some of the more detailed formulas. I hate two table side by side on the same worksheet. Table 1 has columns: Item Sales order # Quantity Expected Delivery Date Table 2 has...

hi all, i would really appreciate your help/advice with the following chalenge: i have a rather large list (over 600 items). the problem is as follow: based on the first name and last name i would need to search in a data base what are the matching email adress: so for example if I have Peter...