Hello all,
I've got info in A1:G100 on sheet2 through
sheet5.
I want to write a vlookup formula on sheet1
that looks for a value on any sheet. There
will only be one instance of the value, but
it could be on sheet2, or sheet4, or...
Can this be done? If so, HOW?!
I've got info in A1:G100 on sheet2 through
sheet5.
I want to write a vlookup formula on sheet1
that looks for a value on any sheet. There
will only be one instance of the value, but
it could be on sheet2, or sheet4, or...
Can this be done? If so, HOW?!