Display data..

[lamchaifbi]

Hi guys, I would like to ask the way of display multi output with one criteria? If I use VLOOKUP it can only show 1 result while I’m actually have 3 records.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
For example;<o></o>
<o></o>
I need to key in my ID number to check how many time I late:<o></o>
<o> </o>
_______ <--enter your ID number<o></o>
<o></o>
DATABASE<o></o>
123 - late for 30 minutes<o></o>
785 - late for 45 minutes<o></o>
444 - late for 15 minutes<o></o>
123 - late for 32 minutes<o></o>
555 - late for 2 minutes<o></o>
123 - late for 17 minutes<o></o>
<o></o>
ONCE I key in the ID number (for example 123) it'll show <o></o>
<o></o>
123____ <--enter your ID number<o></o>
<o></o>
123 - late for 30 minutes<o></o>
123 - late for 32 minutes<o></o>
123 - late for 17 minutes<o></o>

 

[Yahya]

try this way

Excel Workbook
	A	B	C	D	E	F	G	H
1	ID	Des					ID
2	123	late for 30 minutes					123
3	785	late for 45 minutes
4	444	late for 15 minutes
5	123	late for 32 minutes					ID	Des
6	555	late for 2 minutes					123	late for 30 minutes
7	123	late for 17 minutes					123	late for 32 minutes
8							123	late for 17 minutes
Sheet1

Excel 2007

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[lamchaifbi]

Can't really understand, and I tried but no luck, it's not working