Here's how to use VLOOKUP()

VLOOKUP(look for what,where,pull from which column,0)

If your companies run from CA1 to CA5000, then you'll need to target CA1:CE5000 (including address, city, state, & zip)

For address, you'll be pulling column 2

For city, you'll be pulling column 3

State = column 4

Zip = column 5



C2 would look like =VLOOKUP(B2,$CA$1:$CE$5000,2,0)

D2 =VLOOKUP(B2,$CA$1:$CE$5000,3,0)

E2 =VLOOKUP(B2,$CA$1:$CE$5000,4,0)

F2 =VLOOKUP(B2,$CA$1:$CE$5000,5,0)

If you still aren't getting a match, then it just means the drop down list doesn't match the list of companies. If that's the case, I'd check both the list validation and the company names for trailing spaces, out of place commas and periods, or other similar issues.