VLOOKUP Name error

Copper Contributor

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!

2 Replies
VLOOKUP() should be like =VLOOKUP($D$5,Database!A2:C100,3,FALSE)
Thank you Sorry for very late reply I am still working on it. I have to figure out how I created the document again.