Get instant live expert help on I need help with excel indirect vlookup

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I want to understand this formula and see where the source data is coming from =IF(ISERROR(VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),3,0)-VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),2,0)),0,VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),3,0)-VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),2,0))
Solved by S. A. in 19 mins
=IF($C$127="",VLOOKUP(B127,INDIRECT($B$128),10,FALSE),INDEX(INDIRECT($B$128),MATCH(1,(INDIRECT($B$129)=$B$127)*(INDIRECT($B$130)=$C$127),0),10)) shows me #N/A
Solved by M. H. in 20 mins
=VLOOKUP('Cover Sheet'!A4,INDIRECT("'"&Data!A2&"'!A2:O500"),3,FALSE)
Solved by T. H. in 13 mins
explain this formula =vlookup($A$3,INDIRECT("'"&B$2"'!C:H"), 6,0)
Solved by M. H. in 17 mins
Having trouble with a vlookup function with Indirect on different sheet
Solved by T. U. in 25 mins