Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

Excel - VLOOKUP won't return text?

=VLOOKUP(AD15,CUID!$A$1:$A$45,2,FALSE)

AD15=4306889

CUID tab is just two columns.  The value 4306889 is in A6.  In B6 the text is 'Ace Hardware'.  My formula above is returning   #REF!

Any ideas?  I just want to find the value in AD column in column A of CUID tab and return the text value in corresponding row in Column B on CUID tab.....
0
elwayisgod
Asked:
elwayisgod
1 Solution
 
tjc123IT DirectorCommented:
Try this:

=VLOOKUP(AD15,CUID!$A$1:$B$45,2,FALSE)
0
 
elwayisgodAuthor Commented:
How the hell I didn't goto column B in my array is beyond me.. I'm getting tired :)  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now