A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Vlookup problem



 
 
Thread Tools Display Modes
  #1  
Old March 20th, 2010, 12:36 AM posted to microsoft.public.excel.worksheet.functions
tpocccfo
external usenet poster
 
Posts: 1
Default Vlookup problem

I am having a problem with a vlookup fromula returning an #N/A value when
using a cell with another vlookup formula as the lookup_ value. I created
this same spreadsheet a year ago and it worked fine. I even opened the old
one and I can't see any differences at all. I'd appreciate any help anyone
can give.
--
tpocccfo
  #2  
Old March 20th, 2010, 12:42 AM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default Vlookup problem

We'd be happy to help, but you need to meet us halfway.

What's the formula?
What data is providing the #N/A result?

Regards,
Fred

"tpocccfo" wrote in message
...
I am having a problem with a vlookup fromula returning an #N/A value when
using a cell with another vlookup formula as the lookup_ value. I created
this same spreadsheet a year ago and it worked fine. I even opened the old
one and I can't see any differences at all. I'd appreciate any help anyone
can give.
--
tpocccfo


  #3  
Old March 20th, 2010, 01:01 AM posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle
external usenet poster
 
Posts: 516
Default Vlookup problem

Well, if I understand correctly, what you describe should work and did on my
small test.

So the #N/A says you think the lookup looks the same but it is not.

You say it worked before so perhaps something has corrupted the lookup value
column entries, like some new imported data or someone changed something and
thought they got it back to original data...

Try a =A1=C1 type evaluation on the cells that return the n/a. If False
that is the villian.

HTH
Regards,
Howard


"tpocccfo" wrote in message
...
I am having a problem with a vlookup fromula returning an #N/A value when
using a cell with another vlookup formula as the lookup_ value. I created
this same spreadsheet a year ago and it worked fine. I even opened the old
one and I can't see any differences at all. I'd appreciate any help anyone
can give.
--
tpocccfo



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.