Lookup Data in Any Table - LOOKUP() in AppSheet

[@heinerguillen2679]

Excelente! Muchas gracias. Pura vida mae!

[@willysaico]

Excellent, how would I do if I have two columns to compare?

[@appify]

Here are some examples on how to compare columns. [Col1] = [Col2] [Col1] [Col2] [Col1] > [Col2]

[@TalmadgeMcGhoulaghy]

Very well done. Thanks.

[@mangeshmundhe7539]

Thanks sir this is really really helpful!

[@zeroji1624]

sir i am facing some error, my data not search properly, only 1st row data show in lookup cell..... please help me

[@appify]

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.

[@hermawanyulianto2645]

Thank

[@mangeshmundhe7539]

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

[@appify]

I have this video covering parent child relationships aka references. Let me know if this helps. kzbin.info/www/bejne/Z2mxZYemrc6qgZY