Finding Value
 

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.

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.