Google Spreadsheet How to pair data from two separate data ranges
Question: ( by AlexSFr )
Ok, so I have a spreadsheet where employees are making transactions against a requistion number. One sheet keeps tract of the individual transactions which is entered either manually or via a form. Another sheet shows the current requisition which the employee is assigned to.
What I would like to do is pair the currently assigned requsition number of the employee to every transaction the employee made in the first sheet. Example:
Here is also an example spreadsheet:
If this could be done with a query where the combined data is on a third sheet, that would be fine as well.
Thanks in advance.
Solution: Have a look at the following screenshot: