Are you using a column reference for the lookup value? You may need to add [_thisrow]. So you would have [_thisrow].[column] instead of just [column] for the first input.
References between the tables are really confusing sir...could you please nake video on that as well please... thanks in advance... looking forward to learn these things from you
Excelente! Muchas gracias. Pura vida mae!
Very well done. Thanks.
Thanks sir this is really really helpful!
Excellent, how would I do if I have two columns to compare?
Here are some examples on how to compare columns.
[Col1] = [Col2]
[Col1] [Col2]
[Col1] > [Col2]
sir i am facing some error, my data not search properly, only 1st row data show in lookup cell..... please help me
Are you using a column reference for the lookup value? You may need to add [_thisrow]. So you would have [_thisrow].[column] instead of just [column] for the first input.
References between the tables are really confusing sir...could you please nake video on that as well please... thanks in advance... looking forward to learn these things from you
I have this video covering parent child relationships aka references. Let me know if this helps. th-cam.com/video/18N4TpxiwK4/w-d-xo.html
Thank