{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"sports person",null,"Food"]
[null,null,null,"Sachin",null,"Rice"]
[null,null,null,"Dravid",null,"Dal"]
[null,null,null,"yuvraj",null,"Roti"]
[]
[null,null,null,"Please help me in coding the above in Page 1 of the Userform."]
[]
[null,null,null,"I want the above persons name if \"Sports Person\" are selected and the same for the \"food option \"is selected."]

{"sheet":"Sheet2","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sl no.","Name","Result","Desired Result"]
[1,"Santosh",{"$f":"IF(SEARCH(\"sa\",B4,1),\"Hero\",IF(SEARCH(\"su\",B4,1),\"Boy\",IF(SEARCH(\"sha\",B4,1),\"shaan\",\"\")))","v":"Hero"},{"$f":"IF(NOT(ISERROR(SEARCH(\"sa\",B4,1))),\"Hero\",IF(NOT(ISERROR(SEARCH(\"Su\",B4,1))),\"Boy\",IF(NOT(ISERROR(SEARCH(\"Sha\",B4,1))),\"Shaan\",\"\")))","v":"Hero"}]
[2,"Suman",{"$f":"IF(SEARCH(\"sa\",B5,1),\"Hero\",IF(SEARCH(\"su\",B5,1),\"Boy\",IF(SEARCH(\"sha\",B5,1),\"shaan\",\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(NOT(ISERROR(SEARCH(\"sa\",B5,1))),\"Hero\",IF(NOT(ISERROR(SEARCH(\"Su\",B5,1))),\"Boy\",IF(NOT(ISERROR(SEARCH(\"Sha\",B5,1))),\"Shaan\",\"\")))","v":"Boy"}]
[3,"Shanmukh",{"$error":"#VALUE!"},"Shaan"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}