Lookup function does not work properly
1 Excel file, 2 tabs (attached):
1 info tab with 3 fields of which 1 is dropdown (Project), 2 other fields (Nr and Lead) are updated based on 1st.
1 tab with data (contains data for dropdown)
problem;
not all info of Projects in drowdown gives correct info of Nr and Lead
solution?
|