VLookup Not Working with Drop Down List

[treydawgmt]

Hello,

I'm trying to make a PO form for our fire department and it's not quite working. I have a drop down list in Account Name. I want that list to return lines for budget number, project code, and project title from the FD Project Code Data tab. I can either get the wrong information, or no information, but I can't get the right information, but I think I'm doing everything correctly. I'm sure I'm missing something simple, can someone look over this and let me know your thoughts?

Thanks!

[ben8563]

PJ CODE

Please Login or Register  to view this content.

Budget Number

Please Login or Register  to view this content.

PJ Title

Please Login or Register  to view this content.

[JohnTopley]

First, VLOOKUP requires the "search" field to be first column in the range you are using.

In your case, "Account name" is in column D and you want to return Budget # which I think is column C ("Account #")

So either reorder the Project Code data OR use INDEX/MATCH

For G8

Please Login or Register  to view this content.

for G9

Please Login or Register  to view this content.

for C9

Please Login or Register  to view this content.

[treydawgmt]

First, VLOOKUP requires the "search" field to be first column in the range you are using.

In your case, "Account name" is in column D and you want to return Budget # which I think is column C ("Account #")

So either reorder the Project Code data OR use INDEX/MATCH

THAT was the missing part, and that makes total sense now. I wasn't thinking about it right. Thanks!