Forum Discussion
comparing serial numbers from 10 sheets and returning data validation drop down list entries to main
HI, I have a main list on sheet 1 with 239 devices. Column D has the serial numbers on main list. all the other 9 sheets are by building and have the serial numbers in column C, but just for devi...
HiDoyle500,
always assuming I have understood your problem correctly, I would solve it as follows. There may be a simpler solution in the future with VSTACK(), but this is not yet available to me. Therefore I have created an auxiliary column in column 0 of the main sheet, in which I first search the 9 buildings sheets for the serial number with an IFS() function. Then you can use INDIRECT() to build the right cell reference for XLOOKUP().
See also my attached example document. Please see if my example corresponds to your ideas.
- Hi dscheikey
first I want to thank you for your response. It looks like this will work only thing is when I do the ifs () formula on my spread sheet it returns a spill error. I was able to see the Xlookup () formula but not the ifs () formula. if you could write it out so I have a visual reference as I am a newbie to writing formula's like this. thank you very much for any help in this matter.
respectfully,
Doyle 500
