Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-20-2011, 02:11 AM
Catalin.B Catalin.B is offline Reading Values from another sheet Windows Vista Reading Values from another sheet Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

You can try this formula,

=HLOOKUP(Sheet1!A38;Sheet2!A1:E38;38;FALSE)
but if the value from Sheet1!A38 is not found in Sheet2!A1:E38 range, this formula will show #N/A error. There is another method, but you have to tell first if this is what you need.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Reading Values from another sheet Cursor in reading pane Danny DeLoach Outlook 2 08-16-2011 11:58 AM
Reading Values from another sheet Reading a message header papaworx Outlook 5 04-25-2011 05:52 AM
Reading Values from another sheet Reading pane (pain!!!) Angus Outlook 3 04-17-2011 05:38 PM
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM
Word - Calculate and paste values from Excel sheet Augf87 Word 1 07-06-2009 10:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:55 AM.


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