Thread: cell text to auto populate if criteria matches
View Single Post
 
Old 02-05-2015, 06:08 PM
Jackie Jackie is offline Windows 8 Office 2013
Novice
  
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, 16 views)
Last edited by Jackie; 02-05-2015 at 06:22 PM. Reason: example didn't show
Reply With Quote