View Single Post
 
Old 08-09-2022, 02:13 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 648
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

Quote:
Originally Posted by soroush.kalantari View Post
do you mean I should modify my code
No.

Quote:
Originally Posted by soroush.kalantari View Post
or the way the inputs are addressed in the UDF?
for example:
Code:
=matchrow(Sheet1!A2,Sheet71!C3:E9)
or if in another workbook which is open:
Code:
=matchrow([AnotherBook.xlsx]Sheet1!$A$2,[AnotherBook.xlsx]Sheet1!$C$3:$E$7)
Use the mouse to select the ranges and the references will be correct automatically.
Reply With Quote