If I understand your question properly -- yes. And you don't even
need to use VBA. The simplest way would be to use the VLOOKUP() function.

Suppose you had this table:

A B
1 X1 18
2 Y1 15
3 Z1 13

If you want to find  the value in column  B for the value of Z1, you'd
use this formula:

=VLOOKUP("Z1",A1:B3,2,FALSE)

...where:

-- "Z1" is the value you're looking for
-- A1:B3 is the range of the defined table
-- 2 is the table column to return upon finding the row with "Z1"
-- FALSE means only an exact match should return a value