Do you want to find the name or the account number, assuming you look up the
account number in one sheet and you want the name for another sheet

=INDEX(Namesheet_Range,match(account#,Account_rang e,0)

--
Regards,

Peo Sjoblom


"Darryl" wrote in message
...
If account number and in a separate cell the Name appears on next page and
I
want the value that appears in same row which may change from month to
month.
Please show me the formula.