I need help creating a formula that will take column D (Postal Code) from sheet 1 and match it with column C (postal code) from sheet 4 and return corresponding warehouse number for column D sheet 4 in column K sheet 1.
any thoughts
zip code finder.xls
Put this formula in K3 and copy down...
=IFERROR(INDEX(Sheet4!$D$2:$D$235,MATCH(LEFT(D3,5),Sheet4!$C$2:$C$235,0)),"")
Welcome to forum, youngmp502 !
At your column K, drag down.
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thank you so much wenqq3! You saved me so much time. God bless you!
Welcome :D Thanks for feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks