| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
| Sum if another column matches | New Users to Excel | |||
| How can I sort a column of numbers generated by excel RAND funct? | Excel Discussion (Misc queries) | |||
| need funct to match data in 3 seperate spreadsheets column 1 to v. | Excel Discussion (Misc queries) | |||
Linear Mode
