ORIGINAL SPREADSHEET:

A B C

1 cat 2 y

2 dog 3 x

3 pig 1 z

4 owl 0 a

NEW SPREADSHEET

A B C

1 2 y

2 3 x

3 1 z

4 0 a

so basically, i'm trying to fill in column a automaticaly by linking it somehow to the original spreadsheet without re-typing the whole thing again! My current isn't quite perfect but here's what I have:

=IF(MATCH(B1,Original SpreadhseetB1:B4), MATCH(C1,Original SpreadshetC1:C4,0))

The problem with the above formula is it's returning the line where it's located in the original spreadsheet rather than the text.

Can you help me please???

thanks!