Thanks for your prompt reply
Data Tab:
[TABLE="width: 354"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]FNAME[/TD]
[TD]LNAME[/TD]
[TD]DOB[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]SANDRA[/TD]
[TD]ABDULALI[/TD]
[TD="align: right"]01/15/1903[/TD]
[TD="align: right"]1502[/TD]
[/TR]
[TR]
[TD]ANTHONY[/TD]
[TD]ABRAMOVA[/TD]
[TD="align: right"]02/15/1979[/TD]
[TD="align: right"]4048[/TD]
[/TR]
[TR]
[TD]PRECIOUS[/TD]
[TD]ABRAMOVE[/TD]
[TD="align: right"]03/30/1961[/TD]
[TD="align: right"]5807[/TD]
[/TR]
[TR]
[TD]GULNARA[/TD]
[TD]ABRAMOVICH[/TD]
[TD="align: right"]06/01/1959[/TD]
[TD="align: right"]2126[/TD]
[/TR]
[TR]
[TD]CARL[/TD]
[TD]ABRAMS[/TD]
[TD="align: right"]04/29/1998[/TD]
[TD="align: right"]1333[/TD]
[/TR]
[TR]
[TD]CYNTHIA[/TD]
[TD]ABUNDS[/TD]
[TD="align: right"]11/15/1988[/TD]
[TD="align: right"]991[/TD]
[/TR]
[TR]
[TD]VERONICA[/TD]
[TD]ACEVED[/TD]
[TD="align: right"]01/05/1995[/TD]
[TD="align: right"]1763[/TD]
[/TR]
[TR]
[TD]JUDITH[/TD]
[TD]ACEVEDO[/TD]
[TD="align: right"]11/21/1966[/TD]
[TD="align: right"]5113[/TD]
[/TR]
[TR]
[TD]ERNEST[/TD]
[TD]ACOSTA[/TD]
[TD="align: right"]05/24/1969[/TD]
[TD="align: right"]1336[/TD]
[/TR]
</tbody>[/TABLE]
Value Tab:
[TABLE="width: 299"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 241"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]FNAME[/TD]
[TD]LNAME[/TD]
[TD]DOB[/TD]
[/TR]
[TR]
[TD]SANDRA[/TD]
[TD]ABDULALI[/TD]
[TD="align: right"]01/15/1903[/TD]
[/TR]
[TR]
[TD]GULNARA[/TD]
[TD]ABRAMOVICH[/TD]
[TD="align: right"]06/01/1959[/TD]
[/TR]
[TR]
[TD]PRECIOUS[/TD]
[TD]ABRAMOVE[/TD]
[TD="align: right"]03/30/1961[/TD]
[/TR]
[TR]
[TD]JUDITH[/TD]
[TD]ACEVEDO[/TD]
[TD="align: right"]11/21/1966[/TD]
[/TR]
[TR]
[TD]ERNEST[/TD]
[TD]ACOSTA[/TD]
[TD="align: right"]05/24/1969[/TD]
[/TR]
[TR]
[TD]ANTHONY[/TD]
[TD]ABRAMOVA[/TD]
[TD="align: right"]02/15/1979[/TD]
[/TR]
[TR]
[TD]CYNTHIA[/TD]
[TD]ABUNDS[/TD]
[TD="align: right"]11/15/1988[/TD]
[/TR]
[TR]
[TD]VERONICA[/TD]
[TD]ACEVED[/TD]
[TD="align: right"]01/05/1995[/TD]
[/TR]
[TR]
[TD]CARL[/TD]
[TD]ABRAMS[/TD]
[TD="align: right"]04/29/1998[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I'd like to Hyperlink to, lets say the last name, in the Data tab if the data in A,B,and C on the Value tab are present in any one row on the data tab. Does that make sense?
I've worked a good bit with =Hyperlink in the past but it's been linking to tabs and such, I've never linked to a specified cell before. My formula work simply isn't where it used to be. I was thinking maybe an index, match, hyperlink combination. But honestly I'm stumped here for some reason.
Thanks again.