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 place...
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

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