Opublikuj Konkurs

Formula to look up data from a table, based on a given date.

Status: Closed
Nagroda: $20
Uzyskane Zgłoszenia: 2
Zwycięzca: lherreraz

Winner

Opis Konkursu

So i have a table of data ("Misplaced Histroical" sheet). I need a formula or code written that will take the date of the report and the feed type and look up the following samples and analysis in the table. It needs to find the samples closest to the date of the report then copy the results of the samples and paste them back into the process report in the cells provided below:

For MNC
- Module 1 DMC product head ash and paste into (Process Update Form cell c7)
- Module 2 Dmc product head ash and paste into (process update form c8)
- Flotation + 250um % ((process update form c12)

For GRV
- Module 1 DMC product head ash and paste into (Process Update Form cell q7)
- Module 2 Dmc product head ash and paste into (process update form q8)
- Flotation + 250um % (process update form q12)

Zalecane Umiejętności

Winner

Opublikuj Konkurs Taki Jak Ten

Najlepsze zgłoszenia do tego konkursu

jai9100 India

0

Publiczna Tablica Wyjaśnień

ahmadaffan
- 5 lat temu
The file cannot be downloaded . Message box showing "File is corrupted" popup
- 5 lat temu
MaurizioAlfaro
- 5 lat temu
#guaranteed
- 5 lat temu
Organizator Konkursu
- 5 lat temu
#no
- 5 lat temu
areverence
- 5 lat temu
#increaseprize
- 5 lat temu