lookup 3 rows / col

  1. M

    Match 3 Values & CONCATENATE custom text + Cell Reference

    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...
  2. M

    Check Redo Based on Date difference

    Hi, I am looking for a solution to check redo based on multiple criteria. There are basically 2 values in column P and Q it should check both in another sheet named "Previous" if value of P Q matches values in "Previous" and is with 1 month (matching value "Visit") or 3 months (Matching value...
  3. S

    Excel Pattern Matching?

    Is there a way to match patterns of characteristics of data? Assume I have 10,000 rows of data and each is made up for 5 columns. The first column is a unique customer number and the remaining four columns each have either a 1 or 0. There are 15 unique patterns of 1 or 0 in the data set (e.g...
  4. T

    HLOOKUP Question

    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...
  5. D

    Lookup 3 column array.

    Good day, I am struggling with my formula. hopefully I can get some help. I need to compare 3 columns in sheet 1 with sheet 2 and give me the result in column D. I am currently using the following formula. I am not sure what I am doing incorrectly...
  6. C

    Data Search and match through multiple columns and rows

    Hi, I have a table that has the following structure and data; and i have a form that looks like this; I need to make the form link into the table and look through the data to show the correct FIT rate depending on the selections through the form. Everything i have tried so far doesn't work...
  7. G

    Lookup based on 3 criteria, summing and requiring index function

    Hi there, I have hit a slight snag... On the datasheet I need to retrieve numbers from, I have months running down Column A and payroll numbers running down Column B and account codes running across row 2. The problem is I need it to sum based on column A, month and column B, payroll number (a...
  8. R

    Vlookup with multiple variables

    Hi, Thanks in advance. I have a table that needs a vlookup with 2 variables to reach the final result. Its not a nested vlookup inside a vlookup, this wont work. I could make the table 12 times larger and a traditional vlookup will suffice, but is unnessecary if there is a function available...
  9. K

    Lookup 2 vertical and 1 horizontal

    Hi, I have data's(All text) from Column A to Column G and I need a formula which lookup ColA, ColB, Row1 and gives output ColA ColB ColC ColD ColE ColF ColG Scenario Op NC FO FI CP Past What is.. ABC kjha ert sd fgh fg What is.. XYZ qwer ert df fgh aw What is.. MNO er rt ter er What...

Some videos you may like

This Week's Hot Topics

Top