Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2017, 09:41 AM
abbani abbani is offline VLOOKUP using value from CONCATENATE formula Windows 7 32bit VLOOKUP using value from CONCATENATE formula Office 2010 32bit
Novice
VLOOKUP using value from CONCATENATE formula
 
Join Date: Feb 2016
Posts: 11
abbani is on a distinguished road
Default VLOOKUP using value from CONCATENATE formula

I'm trying to use the VLOOKUP function where the LOOKUP_VALUE is in a cell where a CONCATENATION function is used


Always getting #N/A
Reply With Quote
  #2  
Old 08-07-2017, 09:47 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline VLOOKUP using value from CONCATENATE formula Windows 7 64bit VLOOKUP using value from CONCATENATE formula Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

That's because what you are looking for is not there.Perhaps post a sample sheet ( no pics please) showing some data and expected results
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 08-07-2017, 10:31 AM
abbani abbani is offline VLOOKUP using value from CONCATENATE formula Windows 7 32bit VLOOKUP using value from CONCATENATE formula Office 2010 32bit
Novice
VLOOKUP using value from CONCATENATE formula
 
Join Date: Feb 2016
Posts: 11
abbani is on a distinguished road
Default

Dear Pecoflyer
You are right.
It was silly space error
Thanks
Reply With Quote
  #4  
Old 08-07-2017, 11:50 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline VLOOKUP using value from CONCATENATE formula Windows 7 64bit VLOOKUP using value from CONCATENATE formula Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Ah yes, those are sometimes hard to find. The TRIM function helps in some cases
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP using value from CONCATENATE formula Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
VLOOKUP using value from CONCATENATE formula CONCATENATE formula, Comma seperate dmcg9760 Excel 4 12-21-2015 06:45 AM
VLOOKUP using value from CONCATENATE formula VLOOKUP Formula? ekeithjohnson Excel 6 08-28-2014 01:16 PM
IF + VLOOKUP formula help skyline255 Excel 0 09-19-2012 05:05 PM
Help with VLOOKUP formula pattyr Excel 6 08-20-2012 02:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft