I attached a spreadsheet for an example. I have a forumula
=IF(COUNTIFS(Routing!$B:$B,$B4,Routing!$D:$D,K$2),"X","")
The "X" is what will be returned if the statement is true, but I need to change that.
I need it to look up a value that is on another sheet called "Routing" and return the value that is in column F.
Thanks,
Bookmarks