» Retrieving Each Second Number from Two Lists
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Columns A & B contain two lists of numbers.
We want to create a formula that first retrieves a value from List1, then one from List2, and so on down the columns.
Solution:
Use the INDIRECT, IF, MOD, and ROW functions as shown in the following formula:
=INDIRECT(IF(MOD(ROW(),2)=0,"A"&ROW(),"B"&ROW()))
Book Store:
Recommended Books:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Special Edition Using Microsoft Word 2002
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Writing Excel Macros with VBA, 2nd Edition
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
No comments have been submitted.
