» 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 11 Immutable Laws of Internet Branding
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Microsoft Excel 2002 Simply Visual
- Excel 2002 For Dummies®
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
No comments have been submitted.
