Forum Discussion
VLOOKUP for 1000 inventories items
I have an inventory column with 1000 items, each in its own row in a worksheet. Each item has its own price in a different column using the same worksheet. I want to use VLOOKUP that when an inv...
Sounds like you may need to work with absolute references, i.e. fixing cells / ranges. If I interpret correctly, you need a vlookup to work in a number of rows but referencing the same inventory list. If so, you just need to fix the range for the list in the formula with dollar signs ($) so that it doesn't 'shift' when copying down into the below rows:
Example: =VLOOKUP($A2,Sheet2!$A$1:$B$1000,2,FALSE)
Copied down, formula in next row would read:
=VLOOKUP($A3,Sheet2!$A$1:$B$1000,2,FALSE)