I am using a series of VLOOKUP functions to pull the address city state etc from a different workbook, based off the selection of a dropdown menu "NAME_SEARCH".

So I have the function "=TRIM(VLOOKUP(NAME_SEARCH,[Book1.xlsx]CUST_ADDRESS_2!$B:$D,3,FALSE))&""&" "&","&TRIM(VLOOKUP(NAME_SEARCH,[Book1.xlsx]CUST_ADDRESS_2!$B:$E,4,FALSE))" which is the function that picks up the address and state, but for some reason if I put the function [this is the function that gets the zip code] "=VLOOKUP(NAME_SEARCH,[Book1.xlsx]CUST_ADDRESS_2!$B:$F,5,FALSE)" at the end of that, with &","& in between, it gives me a VALUE error. I know this last function works, because it will get the zip code, if I put it in it's own box, but for some reason, adding it on the end of the previous function causes an error. what am I doing wrong?

Just a little background information, the street is in column "C" of the different workbook, City in "D", State in "E", and zip in "F"

Thanks for all your help. Hope to get this fixed quickly! Any questions feel free to ask!