Electrode calibration and verification

%3CLINGO-SUB%20id%3D%22lingo-sub-1495599%22%20slang%3D%22en-US%22%3EElectrode%20calibration%20and%20verification%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495599%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3Ei%20need%20some%20help%20with%20my%20with%20an%20excel.%20it's%20acctually%20a%20bit%20complicated%20cause%20these%20infos%20are%20classified%20but%20i'll%20try%20to%20exlain.%20It's%20three%20sheets%20one%20counts%20a%20kind%20of%20chemical%20content%20according%20to%20measurements%20with%20electrodes%20the%20second%20is%20the%20calibration%20of%20the%20electrodes%20and%20the%20third%20is%20verification.%20And%20my%20problem%20is%20that%20i%20dont%20know%20any%20formulas%20or%20functions%20that%20could%20bring%20the%20latest%20calibration%20from%20sheet%202%20to%20sheet%201%20to%20count%20with%20cause%20there's%20always%20a%20new%20calibration%20to%20every%20electrodes%20in%20like%20every%20two%20days.%20There%20are%20five%20electrodes%20with%20channel%20numbers%20(1-5)%20and%20they%20have%20their%202%20digit%20ID%20numbers%20and%20of%20course%20the%20date%20and%20time%20of%20calibration.%20We've%20been%20using%20a%20method%20of%20adding%20the%20channel%20number%20to%20the%20date%20or%20something%20like%20that%20and%20using%20VLOOKUP%20on%20the%20calibration%20sheet.%20So%20my%20question%20is%20if%20is%20there%20any%20chance%20that%20I%20type%20the%20electrode%20channel%20or%20the%20ID%20on%20the%20first%20sheet%20and%20it%20gives%20me%20the%20latest%20calibration%20to%20count.%3C%2FP%3E%3CP%3EThanks%20a%20lot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1495599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi

i need some help with my with an excel. it's acctually a bit complicated cause these infos are classified but i'll try to exlain. It's three sheets one counts a kind of chemical content according to measurements with electrodes the second is the calibration of the electrodes and the third is verification. And my problem is that i dont know any formulas or functions that could bring the latest calibration from sheet 2 to sheet 1 to count with cause there's always a new calibration to every electrodes in like every two days. There are five electrodes with channel numbers (1-5) and they have their 2 digit ID numbers and of course the date and time of calibration. We've been using a method of adding the channel number to the date or something like that and using VLOOKUP on the calibration sheet. So my question is if is there any chance that I type the electrode channel or the ID on the first sheet and it gives me the latest calibration to count.

Thanks a lot

 

PS:

I'm 20 and I only know excel from highschool also not a native speaker

2 Replies
Highlighted

@kurucviktor Tried to visualise your schedules in the attached workbook, based on your description. A, perhaps, overly simplified example of the use of VLOOKUP. (in the green shades area on the "Channels" tab). Hopefully, it helps you solving your problem.

 

If this doesn't even come close to what you are working on, you can perhaps upload your schedule with some fake data, so that you don't reveal any classified information.

Highlighted
Thank you so much I appreciate it and I’ll se what i can do