Hyperlink - Cell Address, Xlookup

Steel Contributor

Hello Experts,


I am trying to use Xlookup and have it jump to a hyperlink cell on another sheet instead of manually finding the record in 1000's of rows.  I think I probably have incorrect punctuation or the formula is wrong.  


Please see Column J in the attached. 

I am adding an IF condition if Col B contains the word "International*" then look at Col [Intl] and if not then look at Col [Invoice Amount] and I am not sure if that is part of my problem.  


here is the formula:

=IF(C5="International*",HYPERLINK("#"&CELL("address",XLOOKUP(E5,tblPC[[#All],[Intl]],tblPC[[#All],[Intl]],HYPERLINK("#"&CELL("address",XLOOKUP(E5*-1,tblPC[[#All],[Invoice amount]],tblPC[[#All],[Invoice amount]],"Not Found!",0,-1)))))))


The file is pared down to only a few records and my real data set is 1000's of rows. 


thank you very much.

Let me know if you have any questions.


0 Replies