Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2015, 06:08 PM
Jackie Jackie is offline cell text to auto populate if criteria matches Windows 8 cell text to auto populate if criteria matches Office 2013
Novice
cell text to auto populate if criteria matches
 
Join Date: Nov 2014
Posts: 18
Jackie is on a distinguished road
Default cell text to auto populate if criteria matches

Hi

I have a spreadsheet with 2 sheets. I would like a formula to show the team name in column B sheet 2 if column A sheet 2 matches the staff name in sheet 1 - many thanks
Attached Files
File Type: xlsx TEAM.xlsx (9.1 KB, 14 views)

Last edited by Jackie; 02-05-2015 at 06:22 PM. Reason: example didn't show
Reply With Quote
  #2  
Old 02-06-2015, 05:57 AM
gebobs gebobs is offline cell text to auto populate if criteria matches Windows 7 64bit cell text to auto populate if criteria matches Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

=vlookup(f5,$c$5:$d$8,2,false)
Reply With Quote
  #3  
Old 02-06-2015, 07:58 PM
Jackie Jackie is offline cell text to auto populate if criteria matches Windows 8 cell text to auto populate if criteria matches Office 2013
Novice
cell text to auto populate if criteria matches
 
Join Date: Nov 2014
Posts: 18
Jackie is on a distinguished road
Default

Thank you gonna give this a try now

Works a treat, thanks so much

Last edited by Jackie; 02-06-2015 at 08:01 PM. Reason: works
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell text to auto populate if criteria matches How to conditionally format cells in Col. A if it matches adjacent cell in Col. B? alshcover Excel 2 06-03-2014 12:50 PM
cell text to auto populate if criteria matches auto cell populate 2 Stevejd58 Excel 3 08-20-2013 04:23 PM
cell text to auto populate if criteria matches auto cell populate Stevejd58 Excel 14 05-13-2013 02:22 AM
Auto populate text help i'm stuck! Word 1 08-13-2010 11:52 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 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