VLookup pulling data from wrong cell
 

: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

--
Message posted from http://www.ExcelForum.com

VLookup pulling data from wrong cell
 

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


--
Regards
Frank Kabel
Frankfurt, Germany


confused:

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

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

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


---
Message posted from http://www.ExcelForum.com/