mrkeck Sharing the Love

19Aug/130

Excel VLOOKUP not working with number

Let's assume you have number in A1 that is not working in a VLOOKUP. Put this formula in B1 "=IF(ISNUMBER(A1*1),A1*1,A1)". Then point the VLOOKUP to B1 instead. That formula will work for numbers and anything else.

Filed under: Excel No Comments