Results 1 to 2 of 2

Vlookup formula syntax

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2015
    Location
    oswestry, england
    MS-Off Ver
    2010
    Posts
    63

    Vlookup formula syntax

    hi all

    im wondering if someone can help

    I run 2 documents at work which show slightly different results for the same orders - I need to see figures from both file dumps

    so ive dropped them into excel on tab 2 and 3 - currently I have managed to get formulas on tab 1 so it pulls info from tab 2

    what I require is for column J ( tab 1 ) to show the figure from column I in tab 3 when the number in column A tab 1 matches column E in tab 3

    hopefully that all makes sense - I have written an example in the spreadsheet

    thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Syntax Error in vlookup(hlookup Formula
    By ExcelFinWizzard in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2014, 07:05 PM
  2. [SOLVED] vlookup syntax
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-24-2014, 01:07 PM
  3. Incorrect Vlookup syntax
    By lordterrin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-04-2014, 05:56 PM
  4. [SOLVED] Proper syntax for a VLOOKUP
    By Ascott82 in forum Excel General
    Replies: 3
    Last Post: 07-02-2012, 11:18 AM
  5. Issue with IF(ISERROR(VLOOKUP syntax
    By jh9 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2011, 12:45 PM
  6. VLOOKUP syntax
    By salfonsi in forum Excel General
    Replies: 9
    Last Post: 02-13-2008, 06:02 PM
  7. [SOLVED] Vlookup syntax
    By SueJB in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-14-2005, 01:05 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