Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VLookup question on Xcel

Status
Not open for further replies.
jake007

jake007

Programmer
Jun 19, 2003
166
US
I am attempting a pretty simple vlookup. If I use the statement =VLookup("701.0954",I1:M11800,4,FALSE) the lookup[ works fine. But, IF I use =VLookup(A2,I1:M11800,4,FALSE) the lookup returns a #NA. Cell A2 contains the value 701.0954, so why wouldn't this work. Putting quotes around a hard coded value seems to be self defeating. All columns are formatted as text.

Jake
 
Sort by date Sort by votes
Ha, got it, had to trim(a2) for this to work...

Jake
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Avayacoolstuff
  • Locked
  • Question
MS quick query question
Replies
1
Views
303
PatrickRoggers
PatrickRoggers
Cpreston
  • Locked
  • Question
whats wrong with Vlookup 2
2
Replies
20
Views
878
SkipVought
S
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
683
Bijugate
Bijugate
Cpreston
  • Locked
  • Question
vlookup issue 1
Replies
4
Views
374
combo
combo
pjw001
  • Locked
  • Question
Question About Outlook Versions 1
Replies
4
Views
1K
stuartjames78
stuartjames78

Part and Inventory Search

Sponsor

Back
Top