cell text to auto populate if criteria matches

Jackie · #1 02-05-2015, 06:08 PM

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

gebobs · #2 02-06-2015, 05:57 AM

=vlookup(f5,$c$5:$d$8,2,false)

Jackie · #3 02-06-2015, 07:58 PM

Thank you gonna give this a try now

Works a treat, thanks so much

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
auto cell populate 2	Stevejd58	Excel	3	08-20-2013 04:23 PM
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