Excel reference to same address of other cell -

i have excel sheet containing product , price information. in sheet try make list of products combine product. want achieve can use 1 cell reference product name , price of product.

i know possible value of cell in reference using functions index , address, not problem. cannot figure out how address product cell pointing at.

example:

+---+-------+--------------+------------+ |   |     |      b       |     c      | +---+-------+--------------+------------+ | 1 | name  |  price       | quantity   | +-------+--------------+------------+ | 2 | test  | 12           | 1          | +---+-------+--------------+------------+ | 3 |       |              |            | +---+-------+--------------+------------+ | 4 | =$a$2 |  price of b2 |------------| +---+-------+--------------+------------+ 

at cell b4 want value of column b of row referenced a4. possible?

yup, use:

=vlookup(a4,a:b,2,false)