I am working on an inventory spread sheet. On sheet 1, a barcode number is scanned into any cell in column A which has addition data in cells B,C & D in the same row. I want to be able to scan the number into any cell in column A sheet 1, it checks sheet 2 for the corresponding number in column A which is in sequential order. When it finds the corresponding number it populates all the corresponding data across the cells in the same row. The cell being scanned into on sheet 1 may be A5 but the sequential number on sheet two may be in cell A43. Any help would be greatly appreciated.