Finding Value

[Darryl]

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.

[Peo Sjoblom]

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_range,0)

--
Regards,

Peo Sjoblom


"Darryl" <[email protected]> wrote in message
news:[email protected]...
> 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.