Thread: [Solved] formula writing for extracting data
View Single Post
 
Old 11-15-2013, 08:40 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
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
You can use Excel's LOOKUP/VLOOKUP/HLOOKUP functions, or a combined INDEX&MATCH function. The attached demo shows how you can use the latter. Simply input any of the ID's found on Sheet1 into A2 on Sheet2 and the names in columns B & C there will be updated.
Attached Files
File Type: xlsx Lookup.xlsx (11.7 KB, 21 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote