Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup | Excel Discussion (Misc queries) | |||
Vlookup Question | Excel Discussion (Misc queries) | |||
Excel crashing when typing VLOOKUP | Excel Discussion (Misc queries) | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
Vlookup with VBA | Excel Discussion (Misc queries) |