column A matches f places the value from g in column b what funct

[Daryl]

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

 

[Gord Dibben]

In B1 enter this formula.

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

Drag/copy down to B10


Gord Dibben MS Excel MVP

 

[Aladin Akyurek]

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)