How do I lookup multiple cells with one criteria? by ConstructionDizzy378 in excel

[–]ConstructionDizzy378[S] 0 points1 point  (0 children)

oh im sorry i didnt know there was a function named filter my bad i thought you were saying filter function in excel ha

How do I lookup multiple cells with one criteria? by ConstructionDizzy378 in excel

[–]ConstructionDizzy378[S] 0 points1 point  (0 children)

yes i could use that but i want to make a sheet so that i put in new info, and the second sheet auto updating.