HYPERLINK on two tables

[mark692]

hi is this possible this table 1 is the search table if i input the code on code column it will give me the link on link column of the given code
table 1

code	link
B2	LINK HERE

<tbody>
</tbody>

different sheet table 2

NAME	CODE
glen	B1
james	B2
ash	B3

<tbody>
</tbody>

 

[mark692]

i found the answer my problem now is what if i have two criteria in table 1?

 

[AliGW]

What is the answer to your problem? Post that, and we can then take it from there.

 

[mark692]

What is the answer to your problem? Post that, and we can then take it from there.

this is the formula ive used in my table

=IFERROR(IF(A2=0,"",HYPERLINK("#'Table2'!"&ADDRESS(MATCH(A2,Table2

,0)+ROW(Table2[[#Headers],[Code]]),COLUMN(Table2[[#Headers],[Code]])),"Click Here")),"")[/QUOTE]

something like that my problem now is i have 2 criteria in table 1 not just only "code"

 

[mark692]

this is what i mean in two criteria can someone help thanks
table 1

code	AGE	link
B2	23	LINK HERE

<tbody>
</tbody>

different sheet table 2

NAME	age	CODE
glen	17	B1
james	23	B2
ash	18	B3

<tbody>
</tbody>