LOOKUP requires your table (col L) to be sorted ascending.
Use VLLOKUP instead. Look here for a tutorial:

http://www.contextures.com/xlFunctions02.html

Pay special attention to the 4th argument of VLOOKUP; don't omit it.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"pm" wrote in message ...
| Still struggling with my lookup formula. The table below is an example of
| what I am trying to accomplish. I am getting inconsistent results. I
| concatenated column H, and I into L. My goal is to find the vendor match in
| the table with column L. And if it matches populate column J with the
| corresponding Location from the table in column D. I am using the following
| formula in J: =LOOKUP(L3,C$1:D$321,D$1:D$321). In this example the 1st and
| 2nd row pulled the right location. But in the 3rd row it pulled the wrong
| location - from the row above. I appreciate any help!
|
|
| H I J L
| 999050539 FORT BEND COUNTY JP#2 LOC1 999050539FORT BEND COUNTY JP#2
| 999120266 JIM WELLS COUNTY JP1 LOC2 999120266JIM WELLS COUNTY JP1
| 999075446 JP 1 WILLIAMSON COUNTY LO16 999075446JP 1 WILLIAMSON COUNTY
|
| Vendor Table:
| C
| D
| 999050539FORT BEND COUNTY JP#2 LOC1
| 999120266JIM WELLS COUNTY JP1 LOC1
| 999074481MONTGOMERY JP #5 LO16
| 999075446JP 1 WILLIAMSON COUNTY LOC4
|
|
|
|
|
|
|
|