Results 1 to 6 of 6

Return adjacent column, from opposite column NEAREST/CLOSEST value, to entered string

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    Hull, England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Question Return adjacent column, from opposite column NEAREST/CLOSEST value, to entered string

    This question sounds simple enough, but eluded on internet searches so far!

    I want a formula in K17, to return adjacent column, from opposite column NEAREST/CLOSEST value, to entered string.

    Spreadsheet attached.

    When value entered in K8 is met, then F2:F127 is searched for the nearest/closest single value, then the adjacent row in COLUMN G (G2:G127) is returned.

    For example if K8 = 48
    Then K17 = £0.13 (Also to complete the calc * K11 = £78.00)

    Cheers
    Attached Files Attached Files
    Last edited by srands; 01-18-2012 at 08:31 AM.

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