In B1 enter this formula.

=VLOOKUP(A1,$F$1:$G$10,2,FALSE)

Drag/copy down to B10


Gord Dibben MS Excel MVP

On Sun, 15 Nov 2009 11:28:01 -0800, Daryl
wrote:

I am trying to have excel enter information in cell b by finding a number in
a, matching it to a cell in f and returning information from g that that
coresponds with the number in a, example

if column A has numbers 1-10, coulmn F has numbers 1-10, column G has
information related to each number so if I place 2 in A, it searches column F
for 2, places information from column G that matches in column B