| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup formula - Excel Version 2002
Can someone provide me with a vlookup formula to compare 2 columns ( Col A
versus Col B) & return the matched values in Column C? -- Thanks, biz |
|
#2
|
|||
|
|||
|
Put this in C1 & copy down
=IF(ISNA(VLOOKUP(B1,$A$1:$A$1000,1,0)),"",VLOOKUP( B1,$A$1:$A$1000,1,0)) "biz" wrote: Can someone provide me with a vlookup formula to compare 2 columns ( Col A versus Col B) & return the matched values in Column C? -- Thanks, biz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup Formula Excel Version 2002 | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
| Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Linear Mode
