Match value from another worksheet, if they match return value from left of matched value

sdwmoore

New Member
Joined
Sep 13, 2019
Messages
1
Hello all-

Trying to cross reference one worksheet with another(old format) and return the relevant data that is in the left column if they match.

HELP
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

offthelip

Well-known Member
Joined
Dec 23, 2017
Messages
1,243
Office Version
2010
Platform
Windows
use the two functions INDEX and MATCH
 

Watch MrExcel Video

Forum statistics

Threads
1,099,503
Messages
5,468,998
Members
406,627
Latest member
IncandenzaH1997

This Week's Hot Topics

Top