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.
