multiple vlookups

  1. T

    Multiple vlookups in a nested if statement

    I am trying to take a list of Product Numbers in Table 1 and put a Type description next to it based on which column the item number appears in a separate table. I can get the separate IF/Vlookup statements to work individually, but not all together. Formula I'm using that doesn't work...
  2. G

    VLOOKUP multiple matches in target list

    <colgroup><col><col><col><col></colgroup><tbody> Operator Number Operator Name Order Number SO 100302 GRISMER, GARY L 4181452 1888173 395660 FOUST, JAMES 4232383 1914638 395660 FOUST, JAMES 4232383 1914638 100171 HANKE, BARRY M 4232383 1914638 380710 EXTINE, CHRISTOPHER 4233261...
  3. B

    Vlookup challenge

    To all EXCEL wizzards - Can you please help me to resolve the following riddle: I have two worksheets. One carries a calendar and looks like the table below: <tbody> Date Title 1/4/17 2/4/17 3/4/17 4/4/17 </tbody> and the second carries the following table: <tbody> DATE 1...
  4. B

    Two Vlookup and provide total of given account number

    Data <TBODY> 10/01/12</SPAN> 2000</SPAN> 3000</SPAN> 4000</SPAN> 5000</SPAN> 6000</SPAN> 1A</SPAN> 1.00 </SPAN> 2A</SPAN> 2.00 </SPAN> 3A</SPAN> 3.00 </SPAN> 4A</SPAN> 4.00 </SPAN> 5A</SPAN> 5.00...
  5. D

    HELP: VLOOKUP ALL Excel Sheets Within A Folder

    hello, let me first say that I'm aware there are numerous threads explaining multiple Vlookups but this is somthing slightly different. I have a report I produce every morning and unfortunately a vital bit of data does not pull through. so I use a different sheet to vlookup them. Sometimes...
  6. J

    HELP Vlookup master needed

    HI HELP!!! I have four workbooks which contains data for agents conversion for example: <table style="border-collapse: collapse; width: 238pt;" width="317" border="0" cellpadding="0" cellspacing="0"><col style="width: 190pt;" width="253"><col style="width: 48pt;" width="64"><tbody><tr...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top