Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Lookup
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2012, 08:50 PM
angie.chang angie.chang is offline Lookup Windows 7 64bit Lookup Office 2010 64bit
Novice
Lookup 		 
Join Date: Jun 2012
Posts: 9
angie.chang is on a distinguished road
Default Lookup
I was wondering if there is formula for my sample file.



For example, Row a3:a5 to show ABC and row a7:a9 to show XYZ.
Attached Files
File Type: xls Sample lookup.xls (22.0 KB, 11 views)
Reply With Quote
  #2  
Old 07-27-2012, 09:45 PM
Catalin.B Catalin.B is offline Lookup Windows Vista Lookup Office 2010 32bit
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
in cell A3, type: =A2, and copy this down to A5. Same operation in cell A7: type =A6 and copy down to A9
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
Lookup LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM
Lookup Lookup a value from non-sorted data udea Excel 12 04-25-2011 04:34 AM
Creating Lookup in Excel vikash kumar Excel 2 12-06-2010 06:50 AM
Lookup Using the LOOKUP Command Grapejuice Excel 2 10-15-2008 02:02 PM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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