Monday, July 16, 2018

yogi_Extract Entity Values For Specified Item From Data In Another Sheet

Google Spreadsheet   Post  #2476

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-16-2018

question by: Remember 13!topic/docs/dlq8Fc_kEEI;context-place=mydiscussions
Extract values from other sheets depending on another value + Transpose

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: