Hey Pete,

I have tried this many different ways and have not been able to get it to
work. Here is a specific example of what I am trying to do. I have a
worksheet called ED in which E35 matches E177 in another worksheet which is
entitled CP. I need what is in K35 to be input into K177 automatically. The
next item may be a match in E10 of ED and E25 in CP at which time I would
need the info in K10 of ED to input into K25 of CP.

Is this making any sense? Thanks again for your help!

K

"Pete_UK" wrote:

The double quotes between the two commas indicate that a blank should
be returned if the value cannot be found in the search range - instead
of returning #NA it will show a blank.

If you have 300 data items in sheet A then you should make the ranges
'Sheet A'!E$1:E$300 and 'Sheet A'!E$1:K$300 - if you have more then
increase them further - these represent where you are trying to find a
match, so you choose the cell references to encompass all your data on
Sheet A.

The formula can be copied down to row 125 (or beyond). The cell
reference E1 will change to E125 if you copy the formula - if you only
want it on row 125 then type the formula into K125 with E125 instead of
E1 immediately after the open bracket.

Hope this helps.

Pete