Search:

Folks... sorry of the very dull question above. I found that I could do what I wanted using VLOOKUP. Dumb, dumb, dumb.

In a workbook, I have an "inputs worksheet". It has data that I want to use across multiple other worksheets in the workbook. Example in worksheet "EX"
A B C
1 12 13 14
2 56...