Column A contains Values 1,1,1,2,2,2,3,3,3
Columns B & C have other values.
How would you do a lookup to display all the three 1's with the information containted in B and C as well??
2007-12-22 20:47:08 · 3 answers · asked by mcsy_2000 1 in Computers & Internet ➔ Software
A B C
1 1 a a
2 1 b b
3 1 c c
4 2 d d
5 2 e e
6 2 f f
If I do a lookup with the Value 1,
I need to return
1 a a
1 b b
1 c c
2007-12-22 20:51:04 · update #1
You might be able to do it with an array formula but it would be far easier just to use the "Filter" options under the Data menu.
Just select one of the cells with a value in it then go to "Data > Filters > Auto Filter" in the top menu. Click the little grey box that appears above Column A and select 1, then it should display the results you're after.
2007-12-22 21:19:57 · answer #1 · answered by Anonymous · 0⤊ 0⤋
1- Place the data you mentioned in (additional details) starting from cell A1
2- Copy and paste the following formula in any cell
=VLOOKUP(A1,A:D,2)
3- Drag it down
2007-12-23 15:32:26 · answer #2 · answered by Waseem 2 · 0⤊ 0⤋
=VLOOKUP(1,B1:C6,
1,0)&VLOOKUP(1,B1:C6,2,0)
All written on one line
2007-12-26 11:28:59 · answer #3 · answered by HazMat 4 · 0⤊ 0⤋