vlookup for data in 2 columns but same row

[kmlynn1010]

Hey everyone,

Can anyone give me a clue on how to begin writing this formula? I have a spreadsheet with addresses - spreadsheet 1. The house number is in column C and the street name is in column E. Is there any way to match in spreadsheet 2, either exactly or in a number range (for house numbers between 100-200), and have it return the data in column K - the zip code?

I've tried a multiple vlookup formula, but I can't seem to get the logic right. Any suggestions?

Thanks!

 

[GorD]

From this table

Book1
	C	D	E	F
1	No	street	Post code
2	23	Street 1	Code 1
3	52	Street 13	Code 2
4	23	Street 2	Code 3
5	43	Street 3	Code 4
6	2	Street 4	Code 5
7	43	Street 5	Code 6
8	3	Street 6	Code 7
9	52	Street 7	Code 8
10	433	Street 8	Code 9
11	2	Street 9	Code 10
12	45	Street 10	Code 11
13	4334	Street 11	Code 12
14	322	Street 12	Code 13
Sheet1

The formula in the other work book would be:

={INDEX([Book1]Sheet1!$E$2:$E$14,MATCH(A4&B4,[Book1]Sheet1!$C$2:$C$14&[Book1]Sheet1!$D$2:$D$14))}

which is an array formula ( ctrl shift enter)

Hope it helps