Use Common Identifier to Populate Cells

Scerabi

New Member
Joined
Jan 29, 2015
Messages
9
I'd like to have the Delay Reason (G2) and Delay Notes (H2) populate in each row where the SYS Parent OLI (C:C) matches. Can do it in Access but am wondering if there's a fairly straightforward way to do so in Excel.

Light & Water.jpg
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,117
Office Version
365
Platform
Windows
You say that you can do it in Access. Can you tell us how you do it in Access?
Are you matching on two tables, and listing fields from the other table?
If that is the case, then you can do the same sort of thing in Excel using the VLOOKUP function, where you lookup a value from one list (table) in another, and then return another field from there.
See: MS Excel: How to use the VLOOKUP Function (WS)
 

Forum statistics

Threads
1,089,635
Messages
5,409,447
Members
403,263
Latest member
naturally_data

This Week's Hot Topics

Top