#1   Report Post  
Darryl
 
Posts: n/a
Default 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.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
finding multiple MIN's Weekend user Excel Worksheet Functions 3 March 26th 05 09:00 AM
finding the second largest number in a list bobf Excel Discussion (Misc queries) 1 February 16th 05 01:19 PM
Finding Median if a value = 1.. help! Greg Excel Worksheet Functions 2 February 13th 05 03:28 AM
Finding Cell References Zokess Excel Discussion (Misc queries) 2 February 4th 05 04:52 PM
How can i imput a formula in excel for finding the area of a regu. Rona Excel Discussion (Misc queries) 2 January 15th 05 08:17 PM


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"