array formula

Try this, it does not look exactly like what you had in mind as I split column B into 2 columns to make it easier for the formula.


HTH

It is almost right however it doesn't seem to search if I only use cell A1. It is requiring me to enter a value in A2 as well. Is there a way to allow the formula to search by A1 if A2 is blank so that it would only search by value?

I am not following how you did a few steps on the formla. am I anble tojust copy the formula and past into wksht2 B5if I have 5 values in the table

I should be able to used conditional formating for the worksheet if I want the value #NUM to be "blank" by making that text white right?

Try this.

HTH

Can I ask one more quick question in regards to your awesome, amazing SS? Do I have to have the number identifier cell in column A on worksheet 2 and 3 or would the Row command (or some derivitive work)

Just curious... I can easily hide that. This is fantastic. I just hope I can replicate it in the real final version!