index match 3 criteria

Dear All, We are using Office 365 and have created an excel file where using GET DATA FROM SQL SERVER Database we are importing a view from a database: The table has the following headers and data according the data of the specific Car and the month ABCDEFG3iddatecardriverSHIFTclient receive...

Hi All, I am working with bar codes of products. Any bar code repeated in specific period is considered redo. For this I have created 4 helper columns which are somewhat fulfilling the need. But I still need to read whole description of work done to specify if it is redo or not. What I am...

Hello, I am new here and hope you can help with with my problem. We have an output from attendance system (is mostly up to 200-300 rows) and need this data to use/input in another file without adding in manually and checking if assigned values to the correct cell. I create connection with...

Hello All, I have some normative data (what I call Index Scores) that are split by age groups (by decade). The "normal index" score is found by looking up two numbers in a table. I have managed to accomplish this with <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px...

Hello, I am trying to work index match with multiple criteria for the 1st time. I am essentially looking up 3 bits of information, one is a product code say 1234 in cell G1, then look for that same code in the stds page A2:A1400. codes are all in column a. I then match the month G1 and look...