Hi,

I have to enter cheque no. in control find to find in say Sheet 1(my data)
to get the Loan Agreement No. the problem is that it i did not have any
record of how many cheque I got or I entered on that date.

I want to enter cheque no. in a new sheet in column A Can I get the
Agreement No. of the cust in the column B.. from my data sheet which has 3
cheques no in three columns respectively..
Is this possible that among these 3 columns my cheque entry in column A
matches
with it and return the Loan Agr No which is in the fourth column next to the
cheque details.

Thanks,
Safi