# vlookup for data in 2 columns but same row

#### kmlynn1010

##### Board Regular
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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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

Replies
1
Views
169
Replies
1
Views
257
Replies
5
Views
411
Replies
4
Views
285
Replies
10
Views
635

1,221,417
Messages
6,159,789
Members
451,589
Latest member
Harold14

### 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.

### Which adblocker are you using?

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

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