pc/office 10

excel version 2404

likely over my head again, but …

I need to generated formula in cells on worksheet to look at cells on other sheets.
I need to be able to paste list of part numbers, and generate the reference in each cell.

-pasting list in column a
all filenames/tabs/cell location will be pasted part number, plus the info contained in column p, labeled as suffix, (the last 2 digits ranging from 70 to 79, to represent columns B-K, labeled as op 10-100

the resulting desired formula is in column L, labeled as CONCAT results. from here, i would have to copy and paste qas the results, i do not want that step either

im sure there is a better way to do this …. is this even plausible?

​pc/office 10excel version 2404 likely over my head again, but …I need to generated formula in cells on worksheet to look at cells on other sheets.I need to be able to paste list of part numbers, and generate the reference in each cell.-pasting list in column aall filenames/tabs/cell location will be pasted part number, plus the info contained in column p, labeled as suffix, (the last 2 digits ranging from 70 to 79, to represent columns B-K, labeled as op 10-100the resulting desired formula is in column L, labeled as CONCAT results. from here, i would have to copy and paste qas the results, i do not want that step eitherim sure there is a better way to do this …. is this even plausible?  Read More

​