Results 1 to 3 of 3

Vlookup, Match Column header

Threaded View

  1. 07-08-2016, 05:41 PM #1
    irajeev
    irajeev is offline
    Registered User
    Join Date
    07-22-2015
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    30

    Vlookup, Match Column header

    Hi

    I am trying to create some columns in a new excel sheet based on existing sheet. On the sheet DATA"Instance number" is unique. and the range for DATA is huge and dynamic. Some times it can go to more than 5000 lines.

    I have an issue as some column numbers change on DATA Tab. So am trying to use Vlook and MATCH to get information on to QUOTE Tab from DATA Tab. But i am getting errors. Can you please help me with the formula

    Regards
    Raj
    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. [SOLVED] Dynamically match Column header text to sum column on another worksheet
    By swiftrain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2015, 04:50 PM
  2. [SOLVED] VLOOKUP returns column where column header matches another cell
    By bridge4444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 11:23 AM
  3. match Sheet1's column header to sheet2's column header and copy range over if matches
    By dwx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2013, 03:35 PM
  4. Need to match to first three characters in column header...
    By mreinhard in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2013, 05:01 PM
  5. Index/Vlookup to MATCH a MAX in a RxC dimenison to the corresponding row header
    By dvo5004 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2010, 10:13 AM
  6. VLookup and Match column header
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2010, 09:26 PM
  7. Match Header...Copy Column
    By mjack003 in forum Excel General
    Replies: 6
    Last Post: 09-23-2005, 09:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1