VLOOKUP Help

A B C D E F G
1 Date Time NO NO2 NOx O2 CO
2 02/20/2012 12:25:05 0 0.1 0.1 9.3 0
3 02/20/2012 12:25:20 0 0 0 9.3 0
4 02/20/2012 12:25:35 0 0 0 9.2 0 SYS NO ZERO
5 02/20/2012 12:25:50 0 0 0 9.2 0 SYS CO ZERO

I was hoping to use =VLOOKUP("SYS NO ZERO",A1:G5,3)

Is there a way to do this?

Also, sometimes the Columns C-G are in a mixed order and sometimes there is an added row for CO2.

Is there a way to do VLOOKUP and make it find the correct columnn to search for the SYS NO ZERO and then search which column has NO and find the correct value.

Thanks for the help

Try

=INDEX(C:C,MATCH("SYS NO ZERO",G:G,0))