Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup pulling data from wrong cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup Pulling Data from one row above | Excel Discussion (Misc queries) | |||
Pivot table pulling wrong value | Excel Discussion (Misc queries) | |||
VLOOKUP PULLING WRONG DATA | Excel Worksheet Functions | |||
pulling data color using vlookup | Excel Discussion (Misc queries) | |||
Vlookup while pulling a cell color and comment | Excel Worksheet Functions |