Returning A Row & Column from a Table array

Y

Yunus

Hi,
I have a table as follows:
Cells A2:A150 List of Names
Cells B1:CX1: List of Duties
The Array, Cells B2:CX150 have Dates is them many are duplicated or
triplicated

I have Created Conditional Formats for the Array as follows:
Cell Value <NOW(0) is Red
Cell Value <NOW(0) +14 is Yellow
Cell Value <NOW(0) + 42 is Orange

What I would like to achieve now, perhaps in a Separate Worksheet, when
I open the workbook daily,
3 Tables indicating the Names & Duties which are now RED, Orange and
Yellow.

I tried to use INDEX & MATCH but confusing myself. Does this require a
VLookup or a IF Function command?
Thanks
 

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

Index Match, IF or Vlookup 0
Setting column width in a table with a macro is not working 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Searching a table of data using an array and returning the array's header?!? 5
Reverse Index Match 2
Parse a column using a VLOOKUP Table and post a result to another cell/column 3
How to create a dropdown list that populates with another list 2
Return a value from one column using an array and a single row 1

Top