Quote Originally Posted by stevekirk
byran,

i did not copy the data correctly the description field is in column c
file changed
steve
Steve,

assuming you mean that the word 'Description' is in column C on the second heading as it is in the first, and that otherwise the columns are as shown, then in Q2 put

=IF(MATCH("Description",C$2:C$999,0)>=ROW(A2),"",IF(ISERROR(VLOOKUP(D2,INDIRECT("F1:H"&MATCH("Description",C$2:C$999,0)),3,FALSE)),"",VLOOKUP(D2,INDIRECT("F1:H"&MATCH("Description",C$2:C$999,0)),3,FALSE)))

Is that the 13 you seek?

---