look up

[thifu3]

Is it possible that if i write the room number and extract all the people in that room?
for example

In one sheet I have

Room 123
Alex
John
Doe

Room 124
Patric
Mark
Roony

and in another sheet i want to look who is in 123 and extract all in that room.
please help

 

[Hui]

Thifu3

Yes that can be done

Could you supply a sample file with sample data to give you a specific answer?

One method maybe a technique like that shown here:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

 

[thifu3]

Thifu3

Yes that can be done

Could you supply a sample file with sample data to give you a specific answer?

One method maybe a technique like that shown here:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

Thifu3

Yes that can be done

Could you supply a sample file with sample data to give you a specific answer?

One method maybe a technique like that shown here:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

thanks Hui,
please find the attached file. the formula would be in "main" sheet and the datas are from "index" sheet.

thanks

 

[Hui]

Pls see attached file
It uses the technique discussed on the previously listed post
The formula for each group of cells has to be manually adjusted but once setup is ok

 

[Khalid NGO]

Hi thifu3,

Using different layout...
I have placed room numbers horizontally in row # 2.

Regards,