- Dec 5, 2016
Hi guys, I am doing a report for work and I used vlookup for some of the cells to go find information from other sheets. The problem is with a particular person's name only... excel gives me #value on specific cells only. Others work fine.... All data type is either general or number. I tried and changed it but nothing... I copied one of the sheets from another person which everything was calculated ok...but still the same problem occurs. Any suggestions ?