Try...

=INDEX($G$2:$G$100,MATCH(A2,$F$2:$F$100,0))

If F is in ascending order, possibly...

=INDEX($G$2:$G$100,MATCH(A2,$F$2:$F$100,1))

=LOOKUP(A2,$F$2:$F$100,$G$2:$G$100)


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