"10" is the column index. Does excel know I'm referring to another workbook
(Main!) and not the workbook A1 is in?

"iliace" wrote:

=VLOOKUP(A1, Main!$A$90:$J$99, 10, FALSE)

On Nov 29, 11:51 pm, reddog_3d
wrote:
Here's my formula:

LOOKUP(A1, Main!$A$90:$A$99, Main!$J$90:$J$99)

what I'm trying to do is tell excel to check if A1 matches anything on
another workbook, if it does, then look at this column and return the
corresponding value in this column.

But for some weird reason it keeps skipping the first two cells in the
range! Like if A1 =Main!A90, it returns Main!J93. Or if A1 =Main!A91, it
returns Main!J94.

This formula works everywhere else - just not on these two cells (Main!A90
and Main!A91)!!!!

I've deleted everything and re-written from fresh, still does it.

If excel had a butt I'd kick it...

I've deleted