0

What is wrong with this if than statement?

Yeinye Soko

January 15, 2018 20:12

None

Follow

 
NL("first","Purchase Line","Expected Receipt Date","Document No.",NL("first","Tracking Specification","Source ID","Serial No.",$H11))

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis January 16, 2018 15:45

  Hello -

  I do not see any problem with the structure of your function.

  You appear to be wanting the first Expected Receipt Date from the Purchase Line table where the Document No. matches the first Source ID in the Tracking Specification table where the Serial No. matches what is in cell H11.

  What issue are you experiencing?