+ Reply to Thread
Results 1 to 6 of 6

Using variables to find values in a different worksheet

  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.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Using variables to find values in a different worksheet

    Use VLOOKUP. Something like:

    =VLOOKUP(var_cell,Reference!A:C,3)

    where var_cell is the cell containing your 1.25.

    Hope this helps.

    Pete

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

    Re: Using variables to find values in a different worksheet

    I am trying to input my variable (a number in bold) and have it return the corresponding number (in italics) for example, I input 1.3 and have it return 1.31 or input 6 and have it return 6.14 the reference data (snippet) is on a different worksheet

    1.2 1.0047 1.21 3.11 6 1.0237 6.14 15.84 10.8 1.0434 11.26 29.06
    1.25 1.0049 1.26 3.24 6.05 1.0239 6.19 15.98 10.85 1.0436 11.32 29.2
    1.3 1.005 1.31 3.37 6.1 1.0241 6.25 16.11 10.9 1.0438 11.37 29.34
    1.35 1.0052 1.361.41 3.5 6.15 1.0243 6.3 16.25 10.95 1.044 11.43 29.48
    1.4 1.0054 3.63 6.2 1.0245 6.35 16.38 11 1.0442 11.48 29.62
    1.45 1.0056 1.46 3.76 6.25 1.0247 6.4 16.52 11.05 1.0444 11.54 29.77
    1.5 1.0058 1.51 3.89 6.3 1.0249 6.46 16.65 11.1 1.0446 11.59 29.91
    Last edited by mesh55; 04-16-2012 at 01:35 AM.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Using variables to find values in a different worksheet

    Please post a sample workbook then I can see what cell references you use.

    Hope this helps,

    Pete

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

    Re: Using variables to find values in a different worksheet

    I have added a sample workbook to aid in what I am attempting to do.
    Attached Files Attached Files

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Using variables to find values in a different worksheet

    Hi,

    the attached workbook does what I think you are after.

    I've set up three named ranges and put a formula in row 3 column 6.

    Hope this helps.

    Pete
    Attached Files Attached Files

+ 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