Lookup Formula Question

[lilsnoop]

I'm hoping someone can help me with this problem. In my workbook I have multiple sheets but I'm attaching a very simple workbook to demonstrate what I'm trying to accomplish. In my "Lookup" tab/sheet. I want to have known Latitude and Longitude data that will exist in columns A&B. Columns C & D will have address numbers and Street Name. I would like my lookup formula to find the longitude and latitude data from my "lookup" sheet, when the matching address information is typed in, in my 2009 sheet. I have to keep the street numerics and street name separate on this worksheet as well. I believe I'll need two separate lookup formulas as I need these formulas to start in cell G4 & H4 in my "GeoCoding1" sheet. Is it possible to have four columns of data to be viewed in a lookup formula? I tried this formula in cell G4 (GeoCoding1 sheet)

Please Login or Register  to view this content.

& this formula in H4 (same sheet)

Please Login or Register  to view this content.

but neither worked.

I'd sure appreciate any assistance and/or advice!

[JBeaucaire]

Since the data is missing from the Geocode sheet, I got this working in H6 on sheet 2009.

=INDEX(Lookup!$A$2:$A$15,MATCH('2009'!F6&'2009'!G6,Lookup!$C$2:$C$15&Lookup!$D$2:$D$15,1))
...array entered (Ctrl-Shift-Enter), and then copied down.

In I6, the same formula with a different Index Column:

=INDEX(Lookup!$B$2:$B$15,MATCH('2009'!F6&'2009'!G6,Lookup!$C$2:$C$15&Lookup!$D$2:$D$15,1))
...also array entered and copied down.

================
By the way, it is a general "tip" to NOT name sheets and ranges using names of Excel functions or other reserved names. The sheet called Lookup should probably have a different name.

[JBeaucaire]

My apologies, I set the last parameter as true, and it needs to be false for this to work correctly:

H6
=INDEX(Lookup!$A$2:$A$15,MATCH('2009'!F6&'2009'!G6,Lookup!$C$2:$C$15&Lookup!$D$2:$D$15,0))

I6
=INDEX(Lookup!$B$2:$B$15,MATCH('2009'!F6&'2009'!G6,Lookup!$C$2:$C$15&Lookup!$D$2:$D$15,0))

...still array entered and copied down.

[lilsnoop]

Thank you very much!!