I have a sheet named "Sheet2", in which two columns has my data. In Column A, i have Equipment ID and In Column B, i have TAO number.
On other sheet named "Final Log", In column E(Equipment ID) and column F(TAO number) i am using the same data
but user will enter this data. Now i want when user enter data in column E, it should automatically fetch it,s TAO number
from Sheet2. Please help me. Attached are snapshots and file
Bookmarks