cross reference

  1. A

    Copying VLOOKUP formula with non-contiguous entries across multiple workbooks

    I'll try to explain this as concisely as possible. I have been given the task of cross-referencing several workbooks and creating a new, more easily-understandable excel document to be distributed internally within the company. It occurred to me that it would go much faster if I could apply a...
  2. M

    Crossrefing

    Hi all, I was wondering if you know if there is a formula to make crossreferences so that if you click on it that you go to the other crosreference. For example: I have an excell sheet with 4 tabs. On the first tab i have in cell b2 a number ad this is the same number as in tab 2 d100. So i...
  3. N

    Delete Row IF condition is met, IF NOT proceed to next condition etc

    Hi everyone, I've been googling my heart out but still haven't found the VBA code / solution I am after. Let's say I've got 2 spreadsheets named spreadsheet1 and spreadsheet2. In spreadsheet1 there are hundreds of rows with relevant data and I have already turned the autofilter on. The unique...
  4. R

    auto filled cross reference

    Hello, i am searching the internet to solve my problem but can't find what i am doing wrong. i want to extract a value from another excelfile of which the name of the file is determined by a value in my excell sheet. I found the code, but the value is only updating when the other file is...
  5. S

    Need a formula to cross search two tables using a string

    Hello everybody! I need help with making a formula where I'll input one string from Table A and I'll return me the code from Table B that has the same string from Table A, let me explain: I have two tables, Table A has a code and a simple description, like "describes employees", table B also...
  6. L

    [Help Needed] Sum IF matching partial text via single cell using numeric values for match

    In excel work book one, I have account codes that look like this. <tbody> 00-1-110-31011 00-1-110-31031 00-1-110-31042 </tbody> This account code occupies one cell and is followed by a $ value in the next adjacent cell. In excel work book two, I have account codes that look like this...
  7. J

    Lost on how to handle this. Cross match/reference? (SUMIF/LOOKUP/INDEX/MATCH)

    HI everyone, so I've trying to figure this out for the last 2 hours. I'm not an Excel guru but I've tried googling and searching in this forum as much as possible and from all the options I tried none worked. I have the following tables / data: Table named BLUE comes from a survey where...
  8. K

    How to consolidate duplicates names in the SAME column?

    As you can see in the table below, I am looking at a company list with each company's value. The plan is to make a pivot table that will sum the values by company (for example, "CardConnect will be summed to 6") However, I am encountering a lot of 'approximate repeats' that won't sum together...
  9. E

    cross referencing a work sheet

    I have a work sheet with following info : Student Id Student name Grade Course 1 Teacher 1 Course 2 Teacher 2 Course 3 Teacher 3 I would like to be able to make two new work sheets with the info sorted out as follows : Teacher 1 (Course info) List of students per...
  10. D

    Linking to future sheets/future files

    To start, I'd like to say this forum is awesome and has saved me more than a few times. Thank you to all the experts! Now, I have a bit of a problem. I have a series of report files documenting daily activity. Usually, these files are saved by month. In otherwords, a daily activity report for...
  11. B

    Return Rows That Match Between Two Tables??

    Hi all, Is there a way to cross reference two tables and return only the rows that match? In the following example I would like a formula that I could put in Columns G and H to give me the provided output. <tbody> Table 1 Table 2 MATCHES A 5 H 6 A 5 B 3 Z 2 D 7 C 8...
  12. B

    Cross-References List for Exact Matches

    Hi All, Is there anyway to create a list of only VLOOKUP Values that are exact matches? I'm trying to create a macro that cross references two tables and populates a list of matches. My current code does the job, but its a pain to go through and delete every row that comes back as #N/A. I could...
  13. L

    Cross reference in dropping list

    Hello Everyone! First of all, let me say that I am not the kind of person who doesn't look for a solution before asking for help. If the solution to my problem is already out there then it's well hidden ! I have a document with several spreadsheets. The first one is my working document...
  14. J

    Help with referencing between to sets of data

    Hi all, Im completely new to the forum, stubbled on it as most of my google searches seemed to bring me here! So I hope that its not too cheeky to dive right in and ask for some help! Sorry if it is :( Basically I have two sets of data. One that states a job needs to be done, the other...
  15. C

    VBA Macro Cross Reference Extraction?

    So I'm having trouble trying to cross reference two worksheets in a workbook and extract the redundant values to a new worksheet to determine overlap. I work in wealth management and I have two lists from different firms of client/adviser information and I need to see what clients are managed...
  16. B

    Help selecting and applying the correct function to return desired results please.

    <style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-weight: 700; }.xl64 { text-align: center; }</style>...
  17. E

    HELP GRATEFULLY APPRECIATED :) Cross Referencing Question

    Hi, I wonder if anyone could kindly help me. I apologize in advance if the terminology I use is wrong, but I will try to explain my problem in best way I can, and I'm praying it makes sense to you guys! I have two separate excel documents. In excel document 1, A5 to A596 contain the names of...
  18. M

    Populate table using cross-referenced data

    Hello, I really hope someone can help me or get me going in the right direction. I have a large project that I am working on but I do not imagine that it is all that difficult, I've just hit a brick wall in my thinking. The project is this: I have a spreadsheet of data provided to me containing...
  19. K

    extract data from list using index

    Hi I have a data dump and want to show all data that meets x criteria. There is a drop down box a the top of the sheet where a date can be selected, once selected i want formulas underneath to pull back all entries relating to that criteria from the database extract which is in a separate...
  20. L

    Cross Reference of two tables to create a third

    If someone could please help: I have the following two sheets: <TBODY> Sheet 1</SPAN> Sheet 2</SPAN> Inventory Required</SPAN> Item1</SPAN> Item 2</SPAN> Item 3</SPAN> Inventory Required</SPAN> Item1</SPAN> Item 2</SPAN> Item 3</SPAN> Product</SPAN>...

Some videos you may like

This Week's Hot Topics

Top