Vlookup Output doesn't appear in report
I have a sheet that references another sheet to complete the fields via vlookup. However, when a run a report on the sheet, the information populated from the vlookup appears blank? How do I get this information to display in my report?
I have a series of complex sheets that need to be tied together without me having to copy and paste data; I'd like the information to automatically be reported.
Thanks!
Best Answer
-
Can you provide some more information on which fields are vlookup and what is not showing up in the report vs. the sheet?
Maybe highlight the cells in the sheet and report.
In general, things to check:
- Report filters to make sure you have no filtered anything out
- If you renamed a field in a sheet after selecting it in a report, you will need to go to the report and reselect it
Make sure you're pointing at the correct sheet
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
Can you provide some more information on which fields are vlookup and what is not showing up in the report vs. the sheet?
Maybe highlight the cells in the sheet and report.
In general, things to check:
- Report filters to make sure you have no filtered anything out
- If you renamed a field in a sheet after selecting it in a report, you will need to go to the report and reselect it
Make sure you're pointing at the correct sheet
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Thanks! Aha, it was user error. The field names were the issue.
-
I believe the problem is that your report does not have the same fields selected as your sheet. Example: your sheet has a Total Story Points but your report does not. And visa-versa.
When you say things are appearing blank, they problem is that you did not select those columns in your report.
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Help Article Resources
Categories
Check out the Formula Handbook template!
