asked on

VLOOKUP Won't Work

MS Excel 2016 - My Vlookup wont work! Please help - simply trying to find a cost center on the tab and bring back the plant name. I've done it on another workbook and it worked - but on this one it won't? I've check formatting and tried xlsx & xlsm? What am I doing wrong!? :) Sample-Problem---VLOOKUP.docx SAMPLE-Problem-Vlookup.xlsmThanks!

N8iveIT

It appears your Cost Center column in your CCR sheet (blue table) is formatted as a number and the Cost Center column in your yellow table is formatted possibly as text (or a non-number). Changing the text-based numbers to numbers should work; see https://support.office.com/en-us/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885.

Tested it and uploaded the resolved spreadsheet; looks like that did it!
RESOLVED_SAMPLE-Problem-Vlookup.xlsm

ASKER CERTIFIED SOLUTION

Ejgil Hedegaard

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SRMoxy

ASKER

YES! the "multiply" option worked finally -- I tried to change column formatting to "general" and to "number" with 0 decimal places... couldn't get it to work. Thanks to you both for your help!! (but I may be back if my next column doesn't work! LOL )