Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As in subject can you reference two tables in IF statement?
I have seen similar approach with ApplyMap.
Perhaps the LookUp function is what you're looking for. If not, you'll probably have to join the two tables first so you can compare the fields.