I would like to accomplish this using labels that allow cross-referencing of individual cells:
The MWE I wrote to mimic this behavior:
\documentclass[a4paper,10pt]{article}
\usepackage{subcaption}
\usepackage{varioref}
\usepackage{hyperref}
\usepackage{cleveref}
\usepackage{tabularray}
\usepackage{xcolor}
\setlength{\parindent}{0mm}
\hypersetup{colorlinks=true}
% EDIT 1: new definitions
% define an ID
\newcommand{\iddef}[1]{\hypertarget{#1}{#1}}
% reference an ID
\newcommand{\idref}[1]{\hyperlink{#1}{#1}}
\begin{document}
% easier screenshots
\vspace*{\fill}
\section{My friends}
\Cref{friends-name} is a comprehensive list of my friends.
\begin{table}[!h]
\centering
\caption{My friends}
\label{friends-name}
\begin{tblr}{}
ID & FIRST NAME & LAST NAME \
% here I would like a label for each of F1, F2, etc. cells
% it doesn't have to be a counter since I specify IDs manually
% at least one of ref/cref/zcref/nameref should appear as a red "F1", "F2" and point to the cell, not the whole table
\iddef{F1} & Alice & Ross \
\iddef{F2} & Bob & Franklin \
\end{tblr}
\end{table}
As seen in \cref{friends-name}, I only have two friends.
\clearpage
\subsection{Statistics about my friends}
\begin{table}[!h]
\centering
\caption{Age of my friends}
\label{friends-age}
\begin{tblr}{colspec={lr}}
ID & AGE (YEARS) \
% here I would like a clickable cross-reference to F1, F2, etc. cells in the first table
% now references are pointing to the whole table (friends-name) and not to single row
%\hyperref[friends-name]{F1} & 20 \
%\hyperref[friends-name]{F2} & 30 \
% EDIT 1: now references are pointing to an individual row, but it's the row below!
\idref{F1} & 20 \
\idref{F2} & 30 \
\end{tblr}
\end{table}
% here I would like F1 to be a clickable cross-reference to F1 cell in the first table
As seen in \cref{friends-age}, the average age among my friends is 25 years, while \idref{F1} is the youngest.
\end{document}
The desired outcome is that when you click a cell reference, your PDF viewer aligns to that cell row. This is helpful for tall tables where you already know each column name, but you want to be read just the values of the cell row.
EDIT 1
Thanks to @Fran suggestions, I've added two new command definitions, but they are pointing one row below

