Find Numbers that equal a specified value

[Utradeshow]

Not really sure how to explain this, but I need to find formula that looks at a range of cells and finds numbers that equals a specified value.
eg. Show what numbers in Column A that equals 100

Book1
	A	B
1	20
2	15
3	30
4	45
5	60
6	5
7		100
Sheet1

 

[Joe4]

Take a look here: Find all combinations of numbers that equal a given sum in Excel

 

[ExcelToDAX]

Here is a YouTube video that can help you.