Showing related tags and posts accross the entire site.
-
Hey all - Geoff here - brand new to the forum and admittedly a novice-intermediate user of Excel (and its Mac cousin - Numbers). In my web search for the solution to my problem, I have already discovered the VLOOKUP and LOOKUP funtions and have it working. Cool stuff, but it does not quite do what I...
-
I teach data analysis using pivot tables in a short course and we usually need to use lookup functions such as VLOOKUP in order to import fields from different data tables into another one before building a pivot table to get the desired analysis results. Sometimes, VLOOKUP is not an appropriate choice...
-
Hi Guys, Good day to you! I am trying to make a training plan and record in one workbook. In training plan i have to put numbers, which represent for key training description and the other sheet - the training record i have to input the actual dates of training they undergone. So, when dates will be...
-
Have a table of data and I need to interpolate a value. The row names are A,B,C,D and the column names have 0.5, 0.6, 0.7, 0.8 etc. If I want to look up in that table under row B for a column value 0.67, how would I accomplish that? Any ideas!?? Thanks!
-
Dear forum users, I am working on a tool which graphically shows the stock coverage in weeks for all products we have, per product. We have pre-defined max coverage and min coverage. On this picture you can see in red the max, in blue the min and in green the actual (projected) coverage. http://docs...
-
Hi, Im working on a part master file where in i would like to do the following. Can someone help me find some solution. 1, By selecting the Model can I get the part nos and description only for this model populated? If so can you let me know the procedure. 2 ,Also once the model is selected, can I select...