Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » VLookUp » errors (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site

  • Covering failed vlookup/matches

    I have a long standing problem. Let's say I have a VLOOKUP like the one below: =VLOOKUP(OFFSET(G4,-$F4+1,-G$3-1)&$F4&"/"&G$3,SurveyData,8,FALSE) which is to say, a relatively time consuming VLOOKUP, repeated 10,000 times on a sheet. Over half of these lookups will not be present...
    Posted to Functions and Formulas (Forum) by Rick Williams on Thu, Mar 13 2008
Page 1 of 1 (1 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.