Look up data in Excel to find data in a list and verify that it's correct Then, perform calculations or display results with the values returned Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and OFFSET functions to find related data in rows and columns in ExcelI have a ecxel sheet which have some product names, and also have a folder which have some pdf files named same as in cell data, like if cell value is apple1, Pdf file name is apple1pdf, i want to know which name file is missing, can we get that in excel somwhow1 As mentioned the earlier answer you can get the list of sheet names by using the wssheetnames But if you know the sheet names you can get that worksheet object by wsget_sheet_by_name ("YOUR_SHEET_NAME") Another way of doing this is as mentioned in earlier answer ws 'YOUR_SHEET_NAME' Share Improve this answer
Fundamental Skills