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

Post by RGFyeW » Tue, 17 Nov 2009 04:28:01


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

Post by Gord Dibbe » Tue, 17 Nov 2009 04:54:42

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

Post by Aladin Aky » Tue, 17 Nov 2009 04:56:47

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)