Match then highlight and return value.

bentxoxo

New Member
Joined
Jan 13, 2016
Messages
29
Hi There,

How can I have the return value highlight in another workbook before being matched and copy into first workbook.

=INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type))

Thanks in advance
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,095,479
Messages
5,444,728
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top