Hi friends,
I want to search by 'Reg. no.' and 'Last name'.
For by reg. no. problem:
If The user enter a reg. no. in cell 'B4' then his/her last name and first name should be retrieve in cell 'C4, D4' respectively.
I used 'vlookup' formula but I'm not getting output after entering a reg. no. in cell 'B4'. I have to go in edit mode pressing 'F2' in cell 'C4, D4' respectively to get the output.
If the user deletes the reg. no. from cell 'B4' then the output is not clearing. Again I have to follow the same process to clear it.
For last name problem:
If the user enter a last name in cell 'F4' then I require a dropdown list in cell 'G4' to select the first name match to last name cell 'F4'; a reg. no. in cell 'H4' which match the last name and first name. There may be several persons in list of same last name but their first name may be different or same; so I require a dropdown list for first name in cell 'G4'.
I require a formula or vba to achieve this target. My first preference is to have a sheet code to achieve it after entering a reg. no. or last name respectively in these two search tables. Both are different tables. It's because sometimes the person may don't know his reg. no. then in this case his entry will be search by his last name; if the person knows his reg. no. then his entry will be search by his reg. no. So I have created these two different tables to search the person's entry.
Any help will be highly appreciated.
Thanking you in anticipation.
Bookmarks