Forum Discussion
Vlookup behaving strangly
Hi All, From last few Months, Vlookup function linked to one particular XLSB file is behaving weirdly.. The XLSB File is created from file which was working fine earlier.. If the XLSB file from whic...
INDIRECT() and COUNTIF() and its cousins are known not to work with closed workbooks.
Are you sure it is the VLOOKUP() that is causing the problem?
Detlef_Lewin
Thanks Lewin..
I am sure it is Vlookup.. Just FYI, Vlookup is nested in IFERROR, which is further nested in ROUND.
Also the same formula was working 7-8 months ago.. Facing this issue from last 7-8 months.. Was ignoring it so far.. but it taking much of my bandwidth so thought of checking if any resolutions is available for this issue or is there any issue with my setup / config..
Regards,
Vishal Jain