Matching a cell in a non-ordered table

A

Akshay Bakhai

Your question is a bit unclear.

In column H you are populating values from the next
(following) row. Thus H1 gets values from valid columns
in row 2; H2 gets values from valid columns in row 3; and
then suddenly H3 gets values from row 1.

How is your data organized? Is it only 3 rows; and you
will every now and then change values in column A to find
results in column H? Or is your data several rows long
(many more rows than 3 rows) and you made a typing mistake
in your question?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want only rows with populated data 1
Next-To-Last, Non-Blank, Rightmost Value in a Row 6
Conditional Time Calculation 10
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Index Match to ignore blank cells 0
Last non-zero 5
Match Multiple Criteria and Return values positioned above the zero 6
Match a group of cells with another group of cells 1

Top