When searching for numbers, verify that both the lookup value and the data range are formatted consistently as either numbers or text to avoid mismatches.