Hi, Good day all,

I am trying to create a quick search for invoice where I have to select between Day or Night rate.

From there I need the price to appear(from database) and the price need to be displayed based on the job number inserted in another cell.

Eg, the price list is from another sheet consist of two different rate (day & night).

1. I want to select Day Rate.

2. I insert the Job no (106030)

3. The price will show (Day Rate for job 106030) pulling the data from the aforementioned price sheet.

Best Regards,

​Hi, Good day all, I am trying to create a quick search for invoice where I have to select between Day or Night rate.From there I need the price to appear(from database) and the price need to be displayed based on the job number inserted in another cell. Eg, the price list is from another sheet consist of two different rate (day & night).1. I want to select Day Rate.2. I insert the Job no (106030)3. The price will show (Day Rate for job 106030) pulling the data from the aforementioned price sheet. Best Regards,  Read More

​