I have a fairly simple vlookup that looks up check numbers from another worksheet and returns a value in that array. I have performed this for every month of the year except one and the formula works in all of the other spreadsheets. When I go to the worksheet where the array is and use the "Find" tool, it finds the value. When I return to the worksheet where the vlookup formula is, the formula works for that check number I have run find for. Nothing I have tried has work, format painting from spreadsheets that work, copying formulas over, rewriting formulas. This month has more rows than the prior months by about 2000 or so, with a total of 3800. Any help would be useful. I have attached the formula below:
=P4+VLOOKUP(A4,ISIS!A4:L3819,12,FALSE)
Where p4 is a simple dollar value I wish to add to the vlook
up (and this works in prior months)
Column A is the the check number in question, in both work books
Thanks in advance
=P4+VLOOKUP(A4,ISIS!A4:L3819,12,FALSE)
Where p4 is a simple dollar value I wish to add to the vlook
up (and this works in prior months)
Column A is the the check number in question, in both work books
Thanks in advance