Vlookup Output doesn't appear in report

Elizabeth Jones

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!

Ramzi K

@Elizabeth Jones

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:

1. Report filters to make sure you have no filtered anything out
2. 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 K

@Elizabeth Jones

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:

1. Report filters to make sure you have no filtered anything out
2. 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

Elizabeth Jones

Thanks! Aha, it was user error. The field names were the issue.

Ramzi K

@Elizabeth Jones

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.