same ven# and vendor as 6540 is, requires new vendor numbers or making c
olumn 1 the vendor name and the key to your lookup returning the vendor #.
i'd assign new numbers to the vendors.

"pm" wrote:

I am trying to match the ven# and Vendor name on worksheet1 with the table in
worksheet2(see below). And if they match populate a field in worksheet1 with
the location number. There are same ven# with different vendor name and
locations.
I've created a VLOOKUP to find the location; however it only picks up the
first vendor number...can anyone help please?


Ven # vendor name location #
6163 FORT BEND COUNTY CLERK
6540 GALVESTON COUNTY JP#3 Loc7
6540 GALVESTON COUNTY, JP#1 Lo11
6540 JP5 GALVESTON COUNTY Lo12