Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

1
Need Help Pulling Data Across A Workbook Using Query
Post Flair (click to view more posts with a particular flair)
Post Body

HERE IS THE SAMPLE SHEET

I am testing out a workbook where one sheet stores bakers % recipes (that is to say - a recipe name, and then each ingredient is in a %). In the next sheet, a user can select the recipe, enter the amount they want to make, and then hopefully have all of the ingredients calculated out.

If you look at the example sheet, I have hardcoded in what would happen on the Cook sheet if the user selected Reccipe 1 from the drop down and entered 500 in the Amount cell.

I cannot get the query to pull the right row from recipes into cook and then insert the value into every other column. Is query what i want to be using here? Col A & B are the only two inputs on the Cooks sheet - everything else should be calculated based off those two variables.

Author
Account Strength
90%
Account Age
13 years
Verified Email
Yes
Verified Flair
No
Total Karma
2,773
Link Karma
1,490
Comment Karma
1,265
Profile updated: 18 hours ago
Posts updated: 7 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
3 years ago