Jeffrey Green
Well-known Member
- Joined
- Oct 24, 2007
- Messages
- 1,021
I have a list of unique numbers (assignment numbers) on a work sheet, this list SHOULD match another worksheet I have open . . but they don't always, and I want to know what the value is in the column that should match (column B).
So I did a Vlookup . ....
=VLOOKUP(A35,'[December EXPORT HTS TRACKER.xls]Export Tracker'!$A$2:$A$500,2,0)
(A35 is the first row on my spreadsheet where this function lives. Column A on both worksheets is the same value, both sorted ascending.)
I get a Ref# error . . . .if I change the formula to ...$A$2:$A$500,1,0 it returns the correct assignment #, and all cells are populated.
thoughts?
So I did a Vlookup . ....
=VLOOKUP(A35,'[December EXPORT HTS TRACKER.xls]Export Tracker'!$A$2:$A$500,2,0)
(A35 is the first row on my spreadsheet where this function lives. Column A on both worksheets is the same value, both sorted ascending.)
I get a Ref# error . . . .if I change the formula to ...$A$2:$A$500,1,0 it returns the correct assignment #, and all cells are populated.
thoughts?