# 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