VLookup pulling data from wrong cell

C

camilla_dmello

:confused:

I am using a Vlookup function, to match addresses with company name
from another workbook. in some instances, it pulls the data from
previous cell or 2-3 previous cells.

For e.g., I use a Vlookup to find the address of Company C, and get th
address of Company A or B instead. In some instances, it repeats th
address for a number of different companies.

What are possible reasons for this? - I've already checked that I'
matching the right identifier cell
 
F

Frank Kabel

Hi
probably the 4th parameter is missing. Try
=VLOOKUP("company_name",range,col_index,0)
Set the 4th parameter to 0 (FALSE) to search for an exact match

If this does not help you may post your actual formula
 
Top