Atanu Chanda
New Member
Hello All,
First of all I should thank Chandoo for his excellent work which I have silently followed up since late 2009.
I have made a master data table which comprises of almost 6000 rows, each row containing very important employee info.I was trying to build a "Search"-option on the top in-order to fetch the data from the table instead of using auto-filters or ctrl-F.
Table-headers:
EMP_ID YR MNTH DAY ENAME SURNAME DESIGN CLASS TECH_NON-TECH BANK_ACN PAN# PF_ACN PF_DN POSTING DT_JOIN DT_RETIREMENT SERVICE_TENURE
I was only able to workout on a single column-i.e,"EMP_ID" from the data-table.
EMPLOYEE INFORMATION[Selected Table-headers]=OFFSET(DATA[[#Headers],[COLUMNNAME]],MATCH(SEL_EMP_ID,DATA[EMP_ID],0),0)
Would it be possible for you to suggest something by which I can return values,
if there is any "1" Search Parameters filled by the user.[unique values for any employee]
ENTER_EMP_ID: Currently applied.
ENTER_ENAME :
ENTER_PAN# :
ENTER_BANK_ACN:
ENTER_PF_ACN :
First of all I should thank Chandoo for his excellent work which I have silently followed up since late 2009.
I have made a master data table which comprises of almost 6000 rows, each row containing very important employee info.I was trying to build a "Search"-option on the top in-order to fetch the data from the table instead of using auto-filters or ctrl-F.
Table-headers:
EMP_ID YR MNTH DAY ENAME SURNAME DESIGN CLASS TECH_NON-TECH BANK_ACN PAN# PF_ACN PF_DN POSTING DT_JOIN DT_RETIREMENT SERVICE_TENURE
I was only able to workout on a single column-i.e,"EMP_ID" from the data-table.
EMPLOYEE INFORMATION[Selected Table-headers]=OFFSET(DATA[[#Headers],[COLUMNNAME]],MATCH(SEL_EMP_ID,DATA[EMP_ID],0),0)
Would it be possible for you to suggest something by which I can return values,
if there is any "1" Search Parameters filled by the user.[unique values for any employee]
ENTER_EMP_ID: Currently applied.
ENTER_ENAME :
ENTER_PAN# :
ENTER_BANK_ACN:
ENTER_PF_ACN :