Search code examples
google-sheetscell

Selecting cell based on another cell's value

I don't know if this is possible, although I looked and did not find a solution to this:

=PV!A(Results!c2)

I have a field PV which has a lot of values in it on column A.

Results, has results from a race. I am trying to get the cell in column A depending on what the value is in Results. Is this possible?

Solution

  • Use INDEX:

    =INDEX(PV!A:A,Results!c2)