See attached sheet for info. (excel 2007) sheet 611 for reference.
I am working with gas chromatography and the data I get is in the form of
Retention Time (RT) and Area
RT Area
G12 H12
I need to compare the retention time from the sample to the calibration (A8,B8)
There is a slight variation in the retention time from the sample to the calibration. So, there needs to be some sort of tolerance. (this is why vlookup doesnt work)
How would I go about having a function that essentially searches the the calibration retention time for a retention with in the tolerance of the sample value. Then place both the retention time and the area in columns C and D
for example
G16 = 25.529 and matches with B21 (25.535)
I would then want the value 25.529 and 2883.279 placed in columns C and D
Thank you in advance for anything that you can help me with.
Bookmarks