Results 1 to 10 of 10

Lookup nearest value

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2009
    Location
    Nottingham
    MS-Off Ver
    Excel 2003
    Posts
    66

    Lookup nearest value

    Hi all, I understand the VLookup and Hlookup concepts, but I don’t know how to (if possible) lookup a nearest match.

    I have added an example attachment.

    If in E4 – I want to lookup the value of D4, from columns A:B to find the nearest match (4.5 in this instance) and return the value of H (B8) how can I do this?
    Attached Files Attached Files

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