Looking for a formula that will allow me to pull information from "directions" sheet to the "all customers" sheet.
I want it to identify the account numbers and insert directions, garage code and key into the correct places. Note: there are going to be some account numbers that are duplicated but need to be that way for my intended purpose.
Thanks
Last edited by pinas; 08-20-2013 at 03:56 PM.
With VLookup.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I did it with index match. Paste into O2 and copy over and down as far as needed:
=IFERROR(INDEX(Directions!D$2:D$1126,MATCH('all customers'!$A2,Directions!$A$2:$A$1126,0)),"")
Totally saw my corporation on your list.
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks