VLookup pulling data from wrong cell

  • Thread starter Thread starter camilla_dmello
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup 1
Odd VLOOKUP Error 1
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Lookup formula problemo 2
cell referencing 3
Vlookup help required 19
a Vlookup question 4
VLOOKUP Trim vs. No Trim 2

Back
Top