Results 1 to 3 of 3

Return matching data from another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    07-21-2020
    Location
    derby
    MS-Off Ver
    2007
    Posts
    3

    Return matching data from another sheet

    I am looking for help on how to Use VLOOKUP Across Multiple Worksheets.

    I have a sheet with data on it, so part numbers in a column a, description in b column, picking location in c column, and supplier in d column.
    Then on a different sheet i want to be able to write the part number in columb B, and the other info automatically update. so description in column c, picking loc in column d, supplier in column e.
    how is this done?

    Thanks in advance
    Last edited by FDibbins; 08-11-2020 at 03:35 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  2. [SOLVED] When vlookup ragnes is mutiple: How do vlookup value finding occurrence against coresspond
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 34
    Last Post: 07-07-2015, 09:32 AM
  3. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  4. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  5. [SOLVED] Vlookup is not working and giving =vlookup(B2,$T$2:$U$135,2,false) this kind of values.
    By yogeshsharma1981 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2013, 04:08 PM
  6. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  7. Replies: 5
    Last Post: 07-29-2009, 07:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1