Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-04-2013, 01:05 PM
jimboslice jimboslice is offline Windows 8 Office 2013
Novice
 
Join Date: Sep 2013
Posts: 2
jimboslice is on a distinguished road
Smile Vlookup Help


Hi Guys,

I am in some serious need of some help. I'm creating a report with 2 tabs. On the second tab I have a Vlookup under "Was it emailed." It should check the first tab to find a matching invoice number(or doc number). My formula just isn't working to give me a yes or a no.

Any ideas would be very much appreciated!
Attached Files
File Type: xlsx Emailed Sales Invoice Help.xlsx (27.2 KB, 8 views)
Reply With Quote
  #2  
Old 09-04-2013, 09:23 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 616
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

On my machine it is giving a yes-or-no answer; that is, it's giving a Yes answer about 1213387, and about 1234567 as well (which I entered just to be sure).

The problem is that 1213387 is in 'Automate Que'!I:I, but 1234567 isn't, so the two should be giving different answers. I figured it out: In 'Automate Que'!I:I the invoice field is numeric; in 'Sales Invoices'!E:E they're formatted as text. Forget what you typed into the second sheet, check the formatting on it. Excel is looking for a character string in a list of numbers, and not finding a match. You'll need to make them match—make the second sheet numeric in col E, would be my guess, but at any rate they have to be the same in both places.
Reply With Quote
  #3  
Old 09-05-2013, 06:39 AM
jimboslice jimboslice is offline Windows 8 Office 2013
Novice
 
Join Date: Sep 2013
Posts: 2
jimboslice is on a distinguished road
Default

Thanks Bob, didn't seem to change anything. Still not receiving the correct "yes or no" I believe it could be a formula issue... I shouldn't be getting a "yes" no matter what you type in the invoice field on the second tab.
Reply With Quote
  #4  
Old 09-05-2013, 09:42 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 616
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

You didn't ask a question, so maybe I should leave you alone 'til you do. But what the heck: What "didn't seem to change anything"? What (exactly) did you do? You gotta be specific around here or no one will know what information might be helpful to you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using IF and VLOOKUP together Becki Excel 2 04-06-2012 05:32 PM
something like VLOOKUP hanvyj Excel 4 03-13-2012 09:03 AM
Vlookup ibrahimaa Excel 5 03-04-2012 11:24 AM
Vlookup Karen615 Excel 4 09-12-2011 02:30 PM
Help with VLOOKUP sakhtar Excel 2 07-24-2010 07:39 PM


All times are GMT -7. The time now is 10:09 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft