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