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

[sdwmoore]

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

 

[offthelip]

use the two functions INDEX and MATCH