Forum Discussion
Converting outputs from 96 well plate reader from list to matrix
Hello, I am using a 96 well plate reader which outputs data as a list of samples that correlate to a row value and a column value. A simplified version of what it puts out looks like this: Wh...
=VLOOKUP($F2&G$1,CHOOSE({1,2},$B$2:$B$27&$C$2:$C$27,$A$2:$A$27),2,0)
Maybe with this formula. Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021.