PDA

View Full Version : Solved: Match function



khalid79m
05-22-2008, 07:35 AM
:think: 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 ?

Bob Phillips
05-22-2008, 07:56 AM
=INDEX(Sheet2!F2:F20,MIN(MATCH(A1,Sheet2!C2:C20,0),MATCH(A1,Sheet2!D2:D20,0 )))

grichey
05-22-2008, 10:56 AM
ha ha ha

khalid79m
05-29-2008, 09:59 AM
it doesnt work

Bob Phillips
05-29-2008, 10:10 AM
Doesn't it?

grichey
05-29-2008, 10:29 AM
the downfall of the emoticon lol.