Results 1 to 6 of 6

Using variables to find values in a different worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    13

    Using variables to find values in a different worksheet

    Hello,

    I have a reference worksheet that contains many entries. Here is a snippet:

    1.2 1.0047 1.21 3.11
    1.25 1.0049 1.26 3.24
    1.3 1.005 1.31 3.37
    1.35 1.0052 1.36 3.5

    For example, I want to use a variable (ex: var1 = 1.25) from one worksheet and have the value found in on my reference worksheet. Such that I want to use var1 (1.25) and return 1.26 (3rd value on the 1.25 line).

    What is the most efficient way to do this?

    Thanks in advance.
    Last edited by mesh55; 04-12-2012 at 06:20 PM.

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