I created a multi tab spreadsheet to keep track of important data.
on tab B I manually enter all info for each item.
As items get used Tab A Column J i manually enter serial number but i dont want manually enter all data again.

basically what i want is

(Tab A Column H) If Tab A Column Same Row = 00000000 (8 numbers), Search =+TabB! Determine Column and Row for that serial number (Value) and say after searching it discovers that Tab B V23 is the column and row that. i want -Column but keep row and enter value into box.



HTML Code: