Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Michelle Tucker
 
Posts: n/a
Default #N/A error with VLOOKUP

My VLOOKUP was working fine, but now I have added some text boxes and
pictures around the sheet itself. I have allowed for the extra column, but
the VLOOKUP isn't working anymore.
Does it not like pictures? I haven't included these in the area it is
looking at, so it shouldn't get confused.
Unlike me...
--
Michelle Tucker
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Michelle

the #NA error can occur when the VLOOKUP has nothing to lookup ... so my
first suggestion would be to check that the VLOOKUP is still referencing the
correct cells in your workbook.

if that doesn't help, please post your exact VLOOKUP statement and what
you're looking up and what it looks like in the lookup table.

Cheers
JulieD



"Michelle Tucker" wrote in
message ...
My VLOOKUP was working fine, but now I have added some text boxes and
pictures around the sheet itself. I have allowed for the extra column, but
the VLOOKUP isn't working anymore.
Does it not like pictures? I haven't included these in the area it is
looking at, so it shouldn't get confused.
Unlike me...
--
Michelle Tucker



  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

Michelle,

The pictures and textboxes shouldn't make any difference as VLOOKUP just
looks at cells, and those objects don't reside in cells.

Give some details of your data and the formula(s).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michelle Tucker" wrote in
message ...
My VLOOKUP was working fine, but now I have added some text boxes and
pictures around the sheet itself. I have allowed for the extra column, but
the VLOOKUP isn't working anymore.
Does it not like pictures? I haven't included these in the area it is
looking at, so it shouldn't get confused.
Unlike me...
--
Michelle Tucker



  #4   Report Post  
Michelle Tucker
 
Posts: n/a
Default

Don't know why it's working now, but it is, so not a problem!!!

"JulieD" wrote:

Hi Michelle

the #NA error can occur when the VLOOKUP has nothing to lookup ... so my
first suggestion would be to check that the VLOOKUP is still referencing the
correct cells in your workbook.

if that doesn't help, please post your exact VLOOKUP statement and what
you're looking up and what it looks like in the lookup table.

Cheers
JulieD



"Michelle Tucker" wrote in
message ...
My VLOOKUP was working fine, but now I have added some text boxes and
pictures around the sheet itself. I have allowed for the extra column, but
the VLOOKUP isn't working anymore.
Does it not like pictures? I haven't included these in the area it is
looking at, so it shouldn't get confused.
Unlike me...
--
Michelle Tucker




  #5   Report Post  
Michelle Tucker
 
Posts: n/a
Default

It's started working, but don't know why. Oh well, fingers crossed!

"Bob Phillips" wrote:

Michelle,

The pictures and textboxes shouldn't make any difference as VLOOKUP just
looks at cells, and those objects don't reside in cells.

Give some details of your data and the formula(s).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michelle Tucker" wrote in
message ...
My VLOOKUP was working fine, but now I have added some text boxes and
pictures around the sheet itself. I have allowed for the extra column, but
the VLOOKUP isn't working anymore.
Does it not like pictures? I haven't included these in the area it is
looking at, so it shouldn't get confused.
Unlike me...
--
Michelle Tucker




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup Doron Klein Excel Discussion (Misc queries) 2 December 5th 04 09:36 AM
Vlookup Question Jeff Excel Discussion (Misc queries) 2 December 2nd 04 03:40 PM
Excel crashing when typing VLOOKUP Nick Excel Discussion (Misc queries) 2 December 2nd 04 03:27 PM
Need help with modifying VLookUp Tom Excel Discussion (Misc queries) 4 December 2nd 04 01:44 AM
Vlookup with VBA Jeff Excel Discussion (Misc queries) 8 December 1st 04 03:41 PM


All times are GMT +1. The time now is 12:23 AM.

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

About Us

"It's about Microsoft Excel"