Excel lookups

[vbacoder12]

I am running into an issue with excel vlookup and I was wondering if you had any suggestions. I have an ID number that has many potential results. But only the 1st result is being selected.
Example
Id=1
Id =1 ,Home
ID=1,DOG

WHEN I DO A VLOOKUP home is being selected for all. I want one row to pick up home. The 2nd to pick up dog

Any thoughts

 

[Joe4]

T=I am afraid your description does not make much sense to me. Can you show us an actual example of your data, formula, and expected result?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

It would also be really helpful if you told us which version of Excel you are actually using (instead of "Prefer Not To Say"), as newer versions of Excel have some new functions that could make some of this easier (once we determine exactly what you are trying to do).

 

[AhoyNC]

It helps to know your version of Excel.
If you have Excel 365 or 2021 with the FILTER function then formula in D2, f not the formula in F2 and drag down.

Book1
	A	B	C	D	E	F
1	ID	Data		Excel 365
2	1	Home		Home		Home
3	2	Cat		Dog		Dog
4	1	Dog
5	3	Bird
Sheet2

Cell Formulas
Range	Formula
D2:D3	D2	=FILTER(B2:B5,A2:A5=1)
F2:F3	F2	=IFERROR(INDEX($B$2:$B$5,AGGREGATE(15,6,(ROW($A$2:$A$5)-ROW($A$2)+1)/($A$2:$A$5=1),ROWS($F$2:F2))),"")
F4:F5	F4	=IFERROR(INDEX(B4:B7,AGGREGATE(15,6,(ROW($A$2:$A$5)-ROW($A$2)+1)/($A$2:$A$5=1),ROWS($F$2:F4))),"")
Dynamic array formulas.