VLOOKUP
June 20th, 2008 Arthur= 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 […]