Need a function to cross reference

Suppose I had a table on Excel like this:

ABC1 0 0 0
ABC2 1 1 1
ABC3 2 2 2

But instead of 3 rows, there were 1000. If I wanted to access information (i.e. column 2 and 4) for the item ABC2 by just typing in 'ABC2', how would I achieve this? I want to be able to do this across different sheets.

Thanks!