Formula to look up data from a table, based on a given date.
- 진행 현황: Closed
- 상금: $20
- 응모작 접수(건수): 2
- 수상자: lherreraz
콘테스트 개요
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)
추천된 기술
이 콘테스트의 최상위 응모작
-
jai9100 India
공개 설명 게시판
콘테스트를 시작하는 방법
-
콘테스트 등록 신속하고 간편한 절차
-
응모작 접수 세계적인 참가 범위
-
최우수 응모작 선정 자료 파일의 다운로드(초간단!)