Pull data from another sheet depending on two values

Options
PJay128
PJay128 ✭✭
edited 12/09/19 in Smartsheet Basics

I need to put the excess data onto another sheet depending on the month and supplier.

This is the sheet Im pulling the data from

So if someone places a request i can track their quota for the month and tell them if they are going to exceed it or not.

 

The other sheet is where they place the request and these are the columns i want to use to get the data

Cheers

Capture.JPG

Capture1.JPG

Comments