vlookup for data in 2 columns but same row

kmlynn1010

Board Regular
Joined
Feb 8, 2005
Messages
95
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!
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
From this table
Book1
CDEF
1NostreetPost code
223Street 1Code 1
352Street 13Code 2
423Street 2Code 3
543Street 3Code 4
62Street 4Code 5
743Street 5Code 6
83Street 6Code 7
952Street 7Code 8
10433Street 8Code 9
112Street 9Code 10
1245Street 10Code 11
134334Street 11Code 12
14322Street 12Code 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
 

Forum statistics

Threads
1,136,307
Messages
5,674,986
Members
419,541
Latest member
freddyboots

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top