Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2013, 01:15 AM
OTPM OTPM is offline Formula Help Windows 7 32bit Formula Help Office 2010 32bit
Expert
Formula Help
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default Formula Help

Hi
I am looking for a formula that will search a separate worksheet for a value on the current worksheet and return the maximum value from a range on the same row that the searched item is found. I have tried various formulae but for some reason I am stuck.
Any help would be appreciated.


Thanks in advance.
Tony
Reply With Quote
  #2  
Old 05-22-2013, 02:29 AM
macropod's Avatar
macropod macropod is offline Formula Help Windows 7 32bit Formula Help Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Tony,

Can you attach a workbook to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-22-2013, 06:28 AM
OTPM OTPM is offline Formula Help Windows 7 32bit Formula Help Office 2010 32bit
Expert
Formula Help
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Paul
Many thanks for your response. I have just resolved my issues with help from a colleague.
Many thanks.
Tony
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Help OTPM Excel 5 02-21-2013 08:03 AM
Formula Help Need help with a formula e_a_g_l_e_p_i Excel 14 02-07-2013 12:37 AM
help with a look up or if formula beb1227 Excel 3 12-31-2011 01:08 PM
Formula Help If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Formula Help Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft