+ Reply to Thread
Results 1 to 5 of 5

Vlookup,Match,Indirect combination formula

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    89

    Vlookup,Match,Indirect combination formula

    HI... I have the data like this..



    Sl.No Name Design. Addre
    1 A DT sdf
    2 B DF dsfsf
    3 C FG sfsfgg



    I just want the data like this


    Sl.No :

    Name :

    Design:

    Addre :

    Here I the normal vlookup hold the same value when the header changed, but I need to change the (correct) data too when the header changed..

    I attached the file too..
    Thank in Advance... I hope I made this understand...
    Attached Files Attached Files
    Last edited by deepanc; 08-27-2013 at 07:00 PM.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Need Help In Vlookup,Match,Indirect

    Try
    =VLOOKUP(H3,NAME,MATCH(G5,A1:C1,0),TRUE)

  3. #3
    Forum Contributor
    Join Date
    07-02-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    197

    Re: Need Help In Vlookup,Match,Indirect

    Why not use copy and transpose?

    Mark the range A1:D11
    Copy
    Select a cell where it will be copied to
    Use Paste special - Values - Transpose

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need Help In Vlookup,Match,Indirect

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Registered User
    Join Date
    01-18-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: Vlookup,Match,Indirect combination formula

    Sorry.... and Thank You.... That formula working nice...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vlookup, indirect and match from multiple tables
    By rudrugis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2013, 06:21 PM
  2. Vlookup using Indirect and possibly Match, return most recent date
    By daivd_vachon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-28-2012, 04:12 AM
  3. [SOLVED] Indirect Function with Vlookup vs. Index/Match
    By Jayule in forum Excel General
    Replies: 4
    Last Post: 07-02-2012, 12:01 PM
  4. Replies: 8
    Last Post: 03-07-2012, 01:35 PM
  5. Problem with INDEX, INDIRECT, MATCH, MATCH
    By JO505 in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 05:51 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1