Formula help to return stats from multiple sheets

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
First NameSurnameAgeURNlength of service
BobSmith33qz4455667793 years
juliePaige27fd4775h332 years
BobSmith34ttt67676556 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
qz445566779

<tbody>
</tbody>
New YorkNone
Brazilttt6767655
AthensNone

<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:

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top