I need a code which can look at the value in sheet1 a1 and then check sheet2 columns c:d for the value held in a1 , if a value is found then give the value in column f for that row. ? does that make sense ?
I need a code which can look at the value in sheet1 a1 and then check sheet2 columns c:d for the value held in a1 , if a value is found then give the value in column f for that row. ? does that make sense ?
=INDEX(Sheet2!F2:F20,MIN(MATCH(A1,Sheet2!C2:C20,0),MATCH(A1,Sheet2!D2:D20,0 )))
Last edited by Bob Phillips; 05-22-2008 at 10:57 AM.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
ha ha ha
it doesnt work
Doesn't it?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
the downfall of the emoticon lol.