Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems with VLOOKUPS?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 VLookups | Excel Worksheet Functions | |||
vlookups | Excel Programming | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
Vlookups | Excel Discussion (Misc queries) | |||
Vlookups | Excel Worksheet Functions |