Small things…
sometimes even very small things mess up everything in your head…something similar happened with me also…had two lists of numbers…some numbers were missing in one…wanted to find out thoes..instead of inserting values in tables then using SQL or using diff on Unix…thought about using Excel for the same…much heard about function VLOOKUP is there…which we can use for such scenarios…so I also tried the same….had heard a lot abt vlookup but was generally heard of it…as when people used to write “=vlookup(bla bla bla bla…)”…i just used to count my heartbeat…and look around…so this was the time when i really needed to learn vlookup so as a normal computer geek wud do…i opened google.com and started searching the same…what i got was really disappointing….everywhere i almost found the same language….(oops….i also checked microsoft help even dat techie lingo didnt help as when you have messed up the things…nothing really gets into your head….)…some of that text…m pasting here with a hope that it wont create copyright issues….i really got nothing out of this…. “Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find. ...