#1
|
|||
|
|||
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 Last edited by Jackie; 02-05-2015 at 06:22 PM. Reason: example didn't show |
#2
|
|||
|
|||
=vlookup(f5,$c$5:$d$8,2,false)
|
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
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 |