lookup multiple criteria

Hello, I have a table which includes statuses (red, yellow, green) which is based on two criterion: Stage and Days. The number of days for each of the statuses varies by the stage. I'm trying to find the easiest way to pull in the Status when I have the Stage and Days. I've included two...

Hi all, I have a sheet where i need to return a value depending on multiple columns. I want to do this to calculate the efficiency of an installation part. The efficiency of the installation part is calculated per batch. I don't want to average all the batch efficiencies. Attached a photo of...

TAB1 has various data across from column A-J. In Column A, i have a date and in Column J i have the same date plus 7 days with a whole load of other stuff in between. In TAB2, i want to select a month in CELL A1 and have the lines below show the data from TAB1 where the date in Column J falls...

Hi, I would appreciate any help with the following problem i have: In 'Sheet1' i have 3 populated columns with the headings 'Date', 'Agent' and 'Stock' and the relevant data underneath to include the dd/mm/yyyy, the selling agents name and the stock code of the item sold. In 'Sheet2' i have 2...

Hello all. I don't have very much experience with Excel but I am really trying to do my best. I am working on a small project and thought that Excel would fit the bill. I have run into a little snag (brain freeze). Here are some details. A friend, who has a small courier company, has asked me...

Search Table <tbody> AA XX 23 AA XY 34 AA XZ 42 BB XX 12 BB XY 13 BB XZ 25 CC XX 10 CC XY 8 </tbody> Present Table <tbody> Criteria 1 Criteria 2 Result BB XX Formula </tbody> I need to build up a formula which searching criteria 1&2 on the 'search table" bring the third...

<TABLE style="WIDTH: 158pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=210 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><TBODY><TR style="HEIGHT...

Hello All <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> I've been working on this all day and I could really do with a hand <o:p></o:p> <o:p></o:p> <o:p></o:p> What I'm looking to do is lookup the NB value (S2) in...

I'm not sure if Excel or Access is the best tool. I am seeking to search for roughly 1,000 unique search strings amongst 100,000 customers and identify all string matches. The customer data set consists of customer ID (column A) and customer name (column B). I would like to return all...