View Single Post
 
Old 08-09-2022, 08:05 PM
soroush.kalantari soroush.kalantari is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Jun 2021
Posts: 47
soroush.kalantari is on a distinguished road
Default

@Ep45cal. Excuse me very much. By @Debaser comment, I understood that I accidentally have attached the wrong file. The correct file is current attachment.(the edit option was not available to modify the original question).
. If you click on sheet2!A1 you can see the problem. Its references are correct and when first written It gave me the correct answer but when I clicked on it its result unexpectedly changed to 0zero.
Attached Files
File Type: xlsm vlookupUdF.xlsm (17.4 KB, 3 views)
Reply With Quote