I have a Lookup formula that will not work only on one sheet in my Workbook

[tewell53]

I am using Microsoft Excel for Microsoft 365 MSO (Version 2412 16.0.18324.20092) 64 bits.

The following code works in cells outside of the area that I have not changed the cell background to white. There is another similar formula that does work. They both point to the same worksheet just different columns.

I get no error message the formula just appears where the results should be. After a little searching I checked, and Lotus compatibility is not checked

Formula that does not work:

=LOOKUP(2,1/('Change History'!D13:D30<>""),'Change History'!D13:D30)

Formula that does work:

=LOOKUP(2,1/('Change History'!B13:B30<>""),'Change History'!B13:B30)

 

[Fluff]

Check that the cell is not formatted as text.

 

[tewell53]

Fluff,

Such a simple thing that I overlooked.

Thanks

 

[Fluff]

You're welcome & thanks for the feedback.