+ Reply to Thread
Results 1 to 6 of 6

Vlookup Issue

  1. 09-17-2015, 11:41 AM #1
    penza
    penza is offline
    Registered User
    Join Date
    09-17-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    35

    Vlookup Issue

    Hi all,
    I have the below table:

    1.png


    I want that the data in 'Value of Time' and 'Invoiced/Recognised' gets automatically updated from another tab which has the following table?

    2.png

    I have tried Vlookup and the following: =VLOOKUP($A5,'Report Data'!A:E,COLUMN('Report Data'!E5:E5),FALSE)
    However it always takes the first value which is: £1452.50 no matter what I change.
    The main issue is that I have multiple tables, and thus a formula that I can paste across every single table would be great.
    Thanks all!
    Reply With QuoteRegister To Reply
  2. 09-17-2015, 11:55 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Vlookup Issue

    Hi, welcome to the forum

    However it always takes the first value which is: £1452.50 no matter what I change.
    and thats all it ever will do. VLOOKUP finds the 1st match and then stops looking.
    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 09-17-2015, 12:02 PM #3
    penza
    penza is offline
    Registered User
    Join Date
    09-17-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    35

    Re: Vlookup Issue

    Hello,
    Sorry about posting a picture.
    Thank you for your prompt reply, please find the attached excel sample.
    Basically I want the data to replicate from the 2nd to table to the 1st in the 'Value of Time' and 'Invoiced/Recognised' tabs only.
    The thing is there are over 50 tables like this too.
    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-17-2015, 03:10 PM #4
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Vlookup Issue

    Enter in E2 and fill down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Enter in F2 and fill down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    OR

    Enter in E2 and fill across and down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  5. 09-21-2015, 04:40 AM #5
    penza
    penza is offline
    Registered User
    Join Date
    09-17-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    35

    Re: Vlookup Issue

    Thank you! Will that formula work if there are multiple tables as I have more jobs with different job codes thus there are over 50 tables?
    Reply With QuoteRegister To Reply
  6. 09-21-2015, 10:00 AM #6
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Vlookup Issue

    With more than 50 separate tables, my immediate thought is NO it won't work. Can all the tables be combined into one table?

    A more complete example of what you are really working with would certainly help in giving a more complete and accurate answer. Can you supply that?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. VLOOKUP issue
    By St3ff3ns in forum Excel General
    Replies: 4
    Last Post: 06-26-2015, 04:15 AM
  2. [SOLVED] VLookUp issue
    By lionlunatication in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-20-2013, 09:33 PM
  3. Vlookup Issue
    By dhyun3 in forum Excel General
    Replies: 3
    Last Post: 10-03-2012, 09:48 AM
  4. Vlookup #N/A Issue
    By glud in forum Excel General
    Replies: 1
    Last Post: 01-18-2012, 04:34 PM
  5. VLOOKUP Issue
    By Zander in forum Excel General
    Replies: 3
    Last Post: 03-18-2009, 05:50 PM
  6. [SOLVED] VLookup Issue
    By Shonte in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-18-2005, 05:30 PM
  7. VLOOKUP issue
    By Jonah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-16-2005, 06:35 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