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...
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
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
