#N/A error with VLOOKUP

[Guest]

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...

 

[JulieD]

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

 

[Bob Phillips]

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)

 

[Guest]

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

 

[Guest]

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