|  

» Retrieving Each Second Number from Two Lists

Problem:

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()))


Rate This Tip
12 34 5
Rating: 2.33     Views: 8786
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments