Results 1 to 11 of 11

Vlookup question

Threaded View

freud1 Vlookup question 12-02-2008, 09:43 AM
StephenR If you change the '1' at the... 12-02-2008, 09:50 AM
NBVC If you use 1, your 1st column... 12-02-2008, 09:53 AM
NBVC Change the last argument to 0... 12-02-2008, 09:52 AM
JBeaucaire Just take out the final... 12-02-2008, 09:58 AM
freud1 thanks guys! I took the... 12-02-2008, 10:07 AM
NBVC You took the last argument... 12-02-2008, 10:09 AM
Cheeky Charlie Actually the default value of... 12-02-2008, 10:07 AM
JBeaucaire =VLOOKUP(SMALL(I8:I14,1),I8:J1... 12-02-2008, 11:23 AM
Tirren Exactly! Removing the final... 12-02-2008, 04:36 PM
Cheeky Charlie ah, I see... yucky! (in my... 12-02-2008, 01:19 PM
  1. #1
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Vlookup question

    Hello,

    I've made a spreadsheet which relies heavily on the VLOOKUP formula.

    I am having trouble with cell BH9, this is supposed to pull the lowest value in area I8:I14 then put the corresponding name in cell BH9.

    I am currently using the formula =VLOOKUP(SMALL(I8:I14,1),I8:J14,2,1)

    However this is kicking out an error in cell BH9 of #N/A

    I don't know what it is as it seems to be working fine for the others.

    You may need to unhide the table as there are Vlookup References which are hidden.

    If you can resolve the formula or give me a better way of doing this then I would be very greatful!

    Thanks

    Spreadsheet Attached
    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