Google Spreadsheet Post #2476
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Jul-16-2018
question by: Remember 13
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/dlq8Fc_kEEI;context-place=mydiscussions
Extract values from other sheets depending on another value + Transpose
Hi,
I have this spreadsheet I'm sharing with 3 different tabs. There are formulas linking two of them ('Raw' and 'Measurements + Selling description') and I would like to extract data from tab 'Measurements + Selling description' to tab 'Description template' based on the item number I write on cell B1 of this last mentioned tab.
Basically I need to figure out the formula to be typed on 'Description template' cell F2 to get the value from 'Measurements + Selling description' cell H3 if I type 1 on 'Description template' cell B1. (I need it to extract the Description information for item 1 in that case). With that formula I would be able to apply the same formula for the other characteristics and use individual formulas for the Measurements which now have a "TRANSPOSE" simple formula.
What I'm doing right now is type it individually for each item every time I need it, but i'm sure it would be much faster if I can find out how to do it this way.
Thanks very much in advance for the help.
This is the spreadsheet:
No comments:
Post a Comment