I have a sheet, that I'd need to put into an excel spreadsheet of
course, but the sheet is layed out

000-003 5
004-005 6

So, I should have them in separate columns I understand from your
reply.

I'm not quite understanding the functions in your formula.

What I want to do is have a master workbook...

Each workbook I have has 4 sheets...sheet 1 has all the info, sheets
2-4 break up the information on sheet 1 in 3 different categories.

So I want to have a master work book that has 3 sheets, one that has
the zip and zone codes to match with the sheet 2 in the first workbook,
the second one to match with the 3rd sheet...and sheet 3 to match with
the 4th sheet.

Your formula

=if(A1="","",Index(Sheet2!A:A,Match(Left(A1,3)*1,S heet2!B:B,0),1))

1 - what does the "","" do? I would assume it would take the range if
I had the numbers "000-003" in one column.

2 - What does the Left(A1,3) do?

3 - What does the B:B,0 do?

Thanks so much for your help.

This will be awesome when I get it to work...it's taking fooorever to
do this manually


--
rockofaith
------------------------------------------------------------------------
rockofaith's Profile: http://www.excelforum.com/member.php...o&userid=34494
View this thread: http://www.excelforum.com/showthread...hreadid=542599