| Home > Forum Home > Automating Data Analysis Tasks > Finding a common string in two columns > Using the VLOOKUP formula in a column | Share |
Using the VLOOKUP formula in a column
Excel Help for Using The Vlookup Formula In A Column in Automating Data Analysis Tasks
| Forum Topic | Login |
Using The Vlookup Formula In A Column | Rate this: (3/5 from 1 vote) |
 | This can be accomplished by using the VLOOKUP formula with a combination of absolute and relative references in Columns C of worksheet 2. Assuming that there are columns headings in worksheet 2 and that there are 100 rows of data in each worksheet, the following solution will work. 1. Enter the following formula in cell C2 of worksheet 2. =VLOOKUP($B2,Sheet1!$A$1:$C$100,3,FALSE) 2. Copy the formula down the column to repeat the matching of column B. The dollar signs in the formula represent absolute references to maintain the same column or row when copying the formula down the column. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Using the VLOOKUP formula in a column in the Excel Business Solutions Directory |