Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2012, 12:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline VLookup is giving me #N/A error, help with data or formula? Windows 7 64bit VLookup is giving me #N/A error, help with data or formula? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
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

I attached a solution making full use of the capacities of INDEX.
For it to work, column headers must be the same


(Hope it's OK for the MAC version)
Attached Files
File Type: xls Xl0000403_gen.xls (303.0 KB, 9 views)
__________________
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

Tags
n/a, text, vlookup



Similar Threads
Thread Thread Starter Forum Replies Last Post
VLookup is giving me #N/A error, help with data or formula? Vlookup help for large amounts of stock data jyfuller Excel 15 09-21-2012 11:35 AM
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
formula to work from data column masterdineen Excel 16 08-09-2012 07:52 AM
VLookup is giving me #N/A error, help with data or formula? formula divide by serio error vthomeschoolmom Excel 1 04-18-2012 02:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 AM.


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