Forum Discussion

BBCKENPO's avatar
BBCKENPO
Copper Contributor
May 21, 2024

VLOOKUP Name error

I am using =Vlookup for a database to display my acct names and passwords.

It seems to be working although I get a #NAME? error.  I am wanting the password to be displayed

The DB is located on a 2nd tab.

 

This my formula:  =VLOOKUP($D$5,Database,3,Database!D2*********FALSE)      (asterisks=password)

Help highlights  $D$5

 

I am very new to Excel.

Thanks in advance!

Formulas and Functions

2 Replies

Sort By
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    May 22, 2024
    VLOOKUP() should be like =VLOOKUP($D$5,Database!A2:C100,3,FALSE)
    • BBCKENPO's avatar
      BBCKENPO
      Copper Contributor
      Jun 28, 2024
      Thank you Sorry for very late reply I am still working on it. I have to figure out how I created the document again.

Resources