Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-21-2012, 11:36 AM
ladygogo78 ladygogo78 is offline VLookup is giving me #N/A error, help with data or formula? Mac OS X VLookup is giving me #N/A error, help with data or formula? Office for Mac 2011
Novice
VLookup is giving me #N/A error, help with data or formula?
 
Join Date: Oct 2012
Posts: 2
ladygogo78 is on a distinguished road
Default VLookup is giving me #N/A error, help with data or formula?

I've searched the web and can't find a solution to my problem with excel mac 2011.

My lookup_values are a combination of both text and numbers (they are manufacturer's part number in Column C).
This is my formula =VLOOKUP(C4:C204,Sheet1!A1:AV86,34,0). I need Delivery Time which corresponds to the other worksheet in Column AH (C34)

I believe the problem is with my data rather than my formula but not sure how to solve it. there's no trailing space, i cleared formats, etc. But I'm still getting the dreaded #N/A value.
I Command F to for the part number and it finds it in the other spreadsheet fine, so don't the values match?

Hope somebody has a solution for me!! I've attached the sample data.
Attached Files
File Type: xlsx vlookuphelp.xlsx (90.2 KB, 13 views)
Reply With Quote
 

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 02:46 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