I have a requirement to be able to enter a formula in cell B1 that looks at a value in A1 and then looks up that value in a column range and IF found anywhere in that column range, enter the the vaue from $A$6.
This formula would be copied down x number of rows in column B but the lookup column range and $A$6 would remain the same.
I hope this makes sense and thank you in advance for any suggestions.
Ken
This formula would be copied down x number of rows in column B but the lookup column range and $A$6 would remain the same.
I hope this makes sense and thank you in advance for any suggestions.
Ken