Posted by Mo on December 23, 2000 3:56 AM
I have a very large spreadsheet, about 5000+ rows and about 20 columns. I'll just give an example to brief example to explain it better.
A B C D E F
1 code good bad recent notrecent signed
2 0258 1 1 1
3 4789 1 1 1
4 7635 1 1
As you have noticed I flag it with a one. I personally would have preffered to have those fancy ticks instead of putting a one, but you need activex knowledge or something like that, and I dont know how to do that( my knowledge of Macro is non existant). Anyway that doesnt matter.
If I need to edit any of this data, I do find then go to edit it. If I want to just view an entry I do a Vlookup. Assume I put a Vlookup formula in C15, then with regards to the above example it will be
VLOOKUP($C$15,$A$2:$F$4,2,FALSE) . This is fine, but the problem is that with Vlookup, I can view it, but I cannot edit it. Is there a way for me to edit it using a vlookup function or any other function.