In sheet 2 i enter a value in cell A1.
i want to find the same value in either sheet 1 or sheet 3 and bring the corresponding row values.
for example when i enter 2 i want it to read from sheet1 and when i enter 3 i want it to read from sheet 3. sheet 1 and sheet 3 will never have duplicate lookup values.
Bookmarks