You are viewing limited content. For full access, please sign in.

Question

Question

=LOOKUP (Table_column, Table_Row, Value)

asked on April 1, 2021

Where is the function to lookup a value in a table like we have in Excel.  I want it to return the row and/or column index depending on where I know to look.  It could be separated into FINDINROW (row, value) and FINDINCOL (column, value).

 

How do I do this without these functions?

1 0

Replies

replied on April 1, 2021 Show version history

=Index(Column,Row)

Oh sorry, that's for grabbing the value from a specific row/column, not finding where it is. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.