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