magpie2000k
Board Regular
- Joined
- Sep 13, 2013
- Messages
- 196
Guys I am working on a spreadsheet and need to buils a search page.
I have 5 tabs where the columns are
<tbody>
</tbody>
The sheets are location ie London Brazil new york Athens
I want to build a search page where I have the first four fields if B2 c2 d2 and e2 and the cells to enter the info in b3 c3 d3 and e3
I want the results to return underneath
<tbody>
</tbody>
What I am really hoping for is that if I dont have all the information to type in to the search fields ie I know only bob Smith it returns the results shown above, but if I know the age is 33 then it would update the results so that I only get the answer in the box next to london. But also that I could just type in the URN (unique reference number if known and get the complete answer.
I hope this makes sense...
oh and on the search page in colum a
You have the cities written.
One last point.
Staff move and as such the same bob smith could have worked with same urn in 2 locations I would like to add length of service in the returned result where that happens
I have 5 tabs where the columns are
First Name | Surname | Age | URN | length of service | |
Bob | Smith | 33 | qz445566779 | 3 years | |
julie | Paige | 27 | fd4775h33 | 2 years | |
Bob | Smith | 34 | ttt6767655 | 6 years |
<tbody>
</tbody>
The sheets are location ie London Brazil new york Athens
I want to build a search page where I have the first four fields if B2 c2 d2 and e2 and the cells to enter the info in b3 c3 d3 and e3
I want the results to return underneath
London |
<tbody> </tbody> | |
New York | None | |
Brazil | ttt6767655 | |
Athens | None |
<tbody>
</tbody>
What I am really hoping for is that if I dont have all the information to type in to the search fields ie I know only bob Smith it returns the results shown above, but if I know the age is 33 then it would update the results so that I only get the answer in the box next to london. But also that I could just type in the URN (unique reference number if known and get the complete answer.
I hope this makes sense...
oh and on the search page in colum a
You have the cities written.
One last point.
Staff move and as such the same bob smith could have worked with same urn in 2 locations I would like to add length of service in the returned result where that happens
Last edited: