Can you write a statement in excel to read a certain cell if another cell says "X"?
I am pulling this information from a different tab onto another tab so I can use it as a collection of data. Lets call the tab I'm pulling from is called Sales.
For Example: IF Sales! J481 has an X then pull from Sales! E481.
Bookmarks