I am trying to build a formula in sheet A where the look up value is a check
#and its searching in sheet b. Then, i want to be able to extract all invoice
#'s and its relevant row of information paid by that check #,it could be 1 or
it could be 15.

for example

sheet A document # document date invoice#
check# 999 return value from sheet b for all these variables based
on ck#

sheet b

check# Document # document date invoice #
998 11111 12/15/03 4898
999 12345 1/1/2004 5464
999 38540 1/25/2004 6085
1000 39001 2/1/2004 6100

please help
thanks