how to look up matching records

**red95** · 07-30-2009, 09:57 PM

i have cell N1 witch is a number example "8832"
cell O1 is text example "state street"
now i have A1 thur A10 as an address "number"
now E1 thur E10 is street address "text"
i need to take n1 match it to A1-A10
then take that row number and see if E1 of that row numbers matches
O1 if it does that that row numer and get g of that number if not keep checking to i find a match
any help would be nice thanks alan myers

**NBVC** · 07-30-2009, 10:00 PM

What is to be returned if a match is found?

This doesn't make sense:

and get g of that number

**red95** · 07-30-2009, 10:14 PM

column a column e column g column n column o

7525 stoney side ln 45623 6767 ardwell
8231 ardwell 45268
6675 andrusia ln 48750
6767 ardwell ct 98547
8233 amble way 55782
8234 almond dr 55698
8235 amarillo dr 43258
8234 main street 11287

want to find the zip code of the address in n1 and o1

**red95** · 07-30-2009, 10:15 PM

6767 is in column n and ardwell is in column o

**NBVC** · 07-30-2009, 10:18 PM

Try:

=Lookup(2,1/((A1:A100=N1)*(E1:E100=O1)),G1:G100)

adjust ranges to suit and add $ signs to make ranges absolute if copying formula down...

**red95** · 07-30-2009, 10:23 PM

thank you just what i needed
thanks again for the help

**NBVC** · 07-30-2009, 10:25 PM

Please don't forget to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save