Hi:

I have recently seen two problems with VLOOKUPS. I have characterized these
as "hiccups". Let me explain.

Yesterday, a VLOOKUP for just one cell just flat out did not work. And, the
problem was just for one cell. In order to have the results that normally
show, I had to copy and paste "criteria" from one cell to another. (And,
typing in the criteria would not work--I had to copy and paste.) Again, this
was just one cell.

In another instance, there was a string of 8 cells within a group of 35
cells that did not get updated properly by the VLOOKUP. These 8 cells were
right in the same group within these 35.

It's hard to explain. But, it's just as if there is a flaw in the use of
VLOOKUPS.

I know. Maybe it was a mistake that I made in the programming. But, I and
several others looked over the programming and did not see any issues.

Has anyone out there noticed any similar problems with VLOOKUPS? To be
honest, that really worries me. I have to use this programming in my wor,k
and I am now worried that such results as seen above could hurt my
creedibility.

Thanks!

childofthe1980s