= VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Let’s say you sell books for a living. You want to keep an inventory of books you are selling, and you charge different amounts based on the type of book; whether the book is paperback, hard cover, or a best seller. You charge $10 for a paperback book, $25 for a […]
So let’s say you have a several columns of data and create a new column that has a forumla. And you want that new forumla to carry through the entire series in a column like this:
Now typically this is not a problem is you are just trying to copy C5 to a few rows but […]
Having difficulty unhiding the top most rows or the left most columns? Here is a simple way of doing is without remembering shortcuts. Here is a simple example.
You first need to make sure that you can see the rows and columns. Goto Tools>Options>View Tab and then make sure there is a check mark […]