Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Excel Cell Reference Problem

Posted on 2011-10-24
Medium Priority
Last Modified: 2012-05-12
I have 2 data sets.  I am pulling a small set of data from a larger set using VLOOKUP.  For some reason, it is not finding the data, even though it is there.  I know there is an issue with formatting.  For example, If I am trying to Lookup "John Smith", it will not return a solution, but when I manually go to the sheet, retype "John Smith" in the same place, the same way, it finds it and returns a solution to my Lookup page.  What am I missing?  I tried changing the formatting to "text" on both sheets (in the Format Cells Menu), but that hasn't worked.  It only seems to work when I re-type the exact same thing in the box.
Question by:Frankkadaf
  • 2
LVL 19

Expert Comment

ID: 37018536
It would be easier to diagnose if you provide an example but the most common problem with a vlookup is not using the final parameter for example: =vlookup(a1,$B1$C55,3,0) - the final ",0" tells vlookup that it should be looking for an exact match and the data in column B is not sorted.

If you provide a sample file we can examine what's going on

LVL 10

Accepted Solution

etech0 earned 2000 total points
ID: 37018579
check if there are spaces before/after the data you are looking in.

Author Closing Comment

ID: 37018707
There was 1 space after the first name in the large data set!  A small but important difference!

LVL 10

Expert Comment

ID: 37018723
Glad to help!

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question