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

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

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

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

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 < XXXX@XXXXX.COM >

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

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)