+ Reply to Thread
Results 1 to 4 of 4

Return value from a reference table

  1. #1
    Registered User
    Join Date
    10-30-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Return value from a reference table

    Hi,

    Wondering if anyone could help me out with this query Ė Iíve done some googling but canít find the answer so not sure if Iím just not searching the right terms or something.

    Iíve got some data in the format:

    ...........Eggs......Bacon
    Ref 1......10.........16.3

    Each row is an observation, with Ref1 being the reference number for the observation

    The allowable values for factor Eggs and factor Bacon are contained within a reference table in the format:

    Eggs............................Bacon
    10.....0.0003...............14.....0.0003
    11.....0.0004...............15.....0.00061
    12.....0.0003...............16.....0.001
    13.....0.00075.............16.1...0.00075
    14.....0.0003...............16.2...0.0001
    15.....0.00061.............16.3...0.0004
    16.....0.001 ...............16.4...0.0009

    Iíd like to insert a formula such that on a separate worksheet there is an output in the format:

    .......................Eggs..........Bacon
    Ref 1...............0.0003.......0.0004

    i.e. excel will look at the value Ď10í held in the Eggs column and return the value Ď0.0003í based on the reference table

    This seems like a fundamental thing to be able to do, but I canít work it out, so any help greatly appreciated!

    Thanks,

    EpsilonX

  2. #2
    Registered User
    Join Date
    10-30-2012
    Location
    Modlin , Poland
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    42

    Re: Return value from a reference table

    you need to use vlookup function
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-30-2012
    Location
    Modlin , Poland
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    42

    Re: Return value from a reference table

    maybe sth like that?
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-30-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Return value from a reference table

    That's great - Thanks a Lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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