Results 1 to 4 of 4

Data Match and lookup from different sheet

Threaded View

  1. 02-20-2019, 02:21 PM #1
    faisal.ta
    faisal.ta is offline
    Forum Contributor
    Join Date
    05-19-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    111

    Data Match and lookup from different sheet

    Hi
    Im Attaching a sheet where in "Master Ref" Sheet H Column, I need the reference to be taken as G2, and it has to look up in sheet "Check " , Match the same in Column A and return to the exact value as in B Column.
    If anyone could help.
    Tried Vlookup, but not happening

    Faisal
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match data (cells containing txt) within set range to a lookup sheet and copy relev. cells
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2015, 10:23 AM
  2. [SOLVED] Lookup/Match from 2 worksheet & populate data based on lookup
    By plcouch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2015, 08:16 PM
  3. match/sort - lookup data from one sheet and link to other sheet -
    By javaidmr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2015, 10:04 AM
  4. [SOLVED] INDEX/MATCH Lookup based on Data from another sheet
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-08-2015, 10:38 PM
  5. Lookup Column of Data match criteria from another sheet Display Items Vertically
    By danallamas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2014, 03:01 AM
  6. [SOLVED] Lookup up from Sheet 1 in Sheet 2 and display additional value in Sheet 1 when match
    By azbridgie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2013, 03:22 PM
  7. Lookup email address in sheet 1, match with sheet 2 and copy row from sheet 2 to sheet 3
    By Guji in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-14-2012, 01:03 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1