Find matching value in another sheet

[CharlieRog]

I have a list of data split across 2 sheets. On sheet 1 I want to type in a value into column E and if the same value is present in Column E on sheet 2 then it copies cell value on the same line in column C and pastes it in column J on sheet 1.

Not sure if this is a lookup that's required?

THANKS IN ADVANCE!

 

[Misca]

A simple formula solution would be something like:

=INDEX(Sheet2!$C$1:$C$20,MATCH($E3,Sheet2!$E$1:$E$20,0))

Just adjust the ranges & sheet names to match your data.

You might want to wrap it in a IFERROR() function if you don't want to see the N/A errors if the value is not found.

If you really want to copy & paste the values between the sheets you're going to need a macro.

 

[Special-K99]

in J1
=INDEX(Sheet2!C$1:C$1000,MATCH(E1,Sheet2!E$1:E$1000,0),1)