http://www.cleverscampcamp.com/camping-list-excel/
Another Excel Question.?
I got this worksheet that has like 1500 products listed in it. and in column D is there category. And there is a total of 56 Categories. What i would like to do is Make a sub category in Column F. Is it possible to have it say. Look up column D and then see it is a cordless phone then automatically fill in D as in office supplies? or if it was camping gear. it would fill in as Outdoor? I know i could use the If function but that only allows a few IF’s i have 56 categories so dose not work for me.
vlookup function is the function to use,
1. insert a blank sheet(say sheet2) and in column A put list of the product names, column B put list of the respective category names
2. VLOOKUP(lookup_value ,table_array, col_index_num, range_lookup) is the general format of the function, in practice put the formula in sheet1 where original data are, and the cell(say D2)is to show category, then put =VLOOKUP(A2, sheet2!A1:B100, 2, false)
the formula will then look in to range in A1:B100 of sheet2 to see if there is a match of product name A2 of Sheet1, if there is it will show the respective value from the 2nd column of the lookup range of sheet2, and display it in D2 of sheet1.
Hope this helps.
Camp Walden – Diamond Point, NY (Part 1)