Forum Discussion

subjectivist's avatar
subjectivist
Copper Contributor
May 11, 2020
Solved

need help with vlookup for VLOOKUP(E2,CD,1,FALSE)

It has come upon me to see why an Excel spreadsheet does not work for a group of users. I'm experienced with VBA. A hidden cell uses the following:  =NOT(ISERROR(VLOOKUP(E2,CD,1,FALSE))) . Some places in VBA code refer to that cell. My question involves  VLOOKUP(E2,CD,1,FALSE) . I don't know what "CD" refers to since that makes no sense.

developer
excel
Formulas and Functions
Macros and VBA
  • jukapil's avatar
    jukapil
    May 11, 2020

    subjectivist Check your name manager, CD might be defined there as a range.

     

    your third parameter "1" will pop up the look up value from E column. So you can correct if required.Seems your  matching two columns.

     

    Thanks

    Kapil

2 Replies

  • jukapil's avatar
    jukapil
    MCT
    May 11, 2020

    subjectivist Check your name manager, CD might be defined there as a range.

     

    your third parameter "1" will pop up the look up value from E column. So you can correct if required.Seems your  matching two columns.

     

    Thanks

    Kapil