I have two spreadsheets:
1st spreadsheet contains zip code and a reference number in two different cells (e.g. Column A contains "Ticket Number" Column B contains "Zip Code")
2nd spreadsheet contains text in one cell that includes both "Ticket Number" and "Zip Code" along with a description of job to performed (Column J)
I'm trying to build one spreadsheet that is capable of looking up and referencing Spreadsheet One "Ticket Number" and "Zip Code" against Spreadsheet Two (Column J) and Extracting the "Zip Code" and "Ticket Number" only and keep it within Spreadsheet One.
Spreadsheet One contains zip code 64128 in cell B3 and Ticket Number C5698065397 in cell B4
Spreadsheet Two cell J468 text reads: "Install Microsoft Server and build out according to customer specs. Job is located in Chicago, IL 60628 please ask for John Fields upon arriving. Customer reference number is C5698065397, due date for job to be completed is 05-Jan-2012 at 23:59"
How can I find and reference zip code and ticket number as contained in spreadsheet one against column J in Spreadsheet two?
1. The ticket number is never the same length, some ticket numbers range from 3 characters to 20 characters, they are never the same length.