[email protected]’s Profile

Community member since January 2019

points
351
Company
National Louis University
About Me
Director of Learning Design and Innovation
National Louis University

3

In Sheet 1, I want to identify the color of the title of a book that matches ISBN number, so long as the book is available in the library.

Sheet 2

Available     |   BookTitle1

Unvailable   |   BookTitle2

Unvailable   |   BookTitle3

Available     |   BookTitle4

Available     |   BookTitle5

 

I want

2

In Sheet 2, I am looking to search Sheet 1 for an instance of a value, that could be in one of four columns.

Sheet 1

COLUMN A | COLUMN B | COLUMN C | COLUMN D | COLUMN E |

ABS 123      |  March         |   26444         |                     |   43454        |

ABS 456      |  June           |