Friday, April 27, 2018

yogi_LookUp And Put In F2:F21 'Acc/Hour Goal' Values From Q2:Q12 For 'Home Store' Listed In A2:A

Google Spreadsheet   Post  #2431

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

question by: Matthew Santibanez
https://productforums.google.com/forum/#!topic/docs/45FzoZSqSf8;context-place=mydiscussions
What formula would resolve taking information from a column and putting a preset?
In this example I am trying to to make the table take the suffix (RB) in Column A and translate that to a designated answer in Column F to $3.45. This is my first complex formula. I can say I have had no luck at this over the last few months I have been playing with this. I am also willing to share the sheet.