VLookup in reports

Poorva Bhawsar · ‎08-27-2024

Hi Community,

If there is vlookup applied in excel, then how to create reports for this? Is there any functionality related to vlookups in servicenow?

Thanks,

Poorva Bhawsar

Dr Atul G- LNG · ‎08-28-2024

Hi @Poorva Bhawsar

Now you bring the real use case 😀

So now it come to SN, and lets see in which tables these 2 records get stored are in same table or 2 different table?

It is like like I want SLA and Incident records where inc record exits in SLA table.

1st Get the both field table

Then see is it same or 2 different table

3rd , how these 2 tables related like as related list or what

Create DB view or use standard reporting ( if Related list is the case ) and get the result.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

Dr Atul G- LNG · ‎08-27-2024

Hi @Poorva Bhawsar

No, it is not available in ServiceNow reporting.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Poorva Bhawsar · ‎08-27-2024

Then how to create reports in servicenow if there is vlookup applied in excel?

Dr Atul G- LNG · ‎08-28-2024

Hi @Poorva Bhawsar

Vlookup is an Excel feature, excel and SN are two different tools/ platform. It depends what action you are doing in Excel and how we can replicate in SN.

Try to break the report like

step 1

Step2

Step 3

and then related upto what extent you an bring excel functionality in SN. If you are same to same as Vlookup, then it is not possible in Standard report.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Poorva Bhawsar · ‎08-28-2024

I know that both are different tools. But here lets take an example, i have two sheets in excel, one has a column xyz, when i click on that record, there is a vlookup applied which has a formula which contains 2 other column data and getting applied on the xyz column record.

So, in the below screenshot, i have clicked on the all active pos column and the row no 3.

This is the vlookup formula i am getting, H3 is the column H and row no. 3 in the above screenshot.

All open pos column A will be considered, so by using H3 and all open pos column A, its displaying the value in all active pos column and row no 3.

So, my question is how we will be creating reports in this case, how to get such type of data in the reports.