shwekhaw

Posts: n/a

Search one column and return value from next column

Hi I am not professional excel user. But I am wondering if anyone can
help me write short formula for the following.
I use MAX(A10:A1000) to get the maximum value in Column A. But I want
return value to be whatever value on the same row under column B.

Thank you.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Return Count for LAST NonBlank Cell in each Row	Sam via OfficeKB.com	Excel Worksheet Functions	12	April 17th 05 10:36 PM
up to 7 functions?	ALex	Excel Worksheet Functions	10	April 12th 05 06:42 PM
lookup from one column return value from another?	Maria	Excel Discussion (Misc queries)	1	April 1st 05 05:57 AM
Search column and move text formula	tommy	Excel Discussion (Misc queries)	0	February 8th 05 06:55 PM
How can I make Excel return the text in column A only if there is.	phatbusa	Excel Worksheet Functions	1	January 26th 05 04:25 PM

All times are GMT +1. The time now is 12:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us