+ Reply to Thread
Results 1 to 2 of 2

Lookup command reading user input cell

  1. #1
    Registered User
    Join Date
    01-02-2008
    Posts
    23

    Lookup command reading user input cell

    Hi,
    I have a table of temperature from 1 to 40 in and in the next column i have the pressure relating to each temperature.

    I have an equation that relates to different figures from the table.

    If the user enters a temperature of say 10 into a specific box, i need the formula to look up what pressure 10 degrees is and apply this to the formula

    Ive attached the document, i dont expect someone to fill it in but the cells should show you the reference points to help me with the formula.

    Thanks
    Lee
    Attached Files Attached Files
    Last edited by ldavison10; 01-07-2008 at 08:46 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064
    In O2...

    =LOOKUP(G6,K3:L43)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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