Excel

[carmino]

Can someone please help? Col A, B, C, contain public information from a
data base I frequently use. I want to match Col D to Col A and extract the
value of DBSqFt and DBYrBuilt. Let me thank you in advance since I don’t know
If I’ll know how to after you respond. My email is carmino@netzero.net.
Thanks,
Carmen

NJACTBB/L	DBSq. Ft.	DBYr Built	GSB/L
102/2	2742	1929	102/7
102/5	2341	1952	104/3
104/2	2813	1926	104/13
104/3	2007	1926	106/11
104/7	3799	1911	201/3
104/13	2059	1965	201/15
106/14	2596	1920	203/5
107/15	2192	1880	203/13
201/3	1640	1951	204/6
201/13	2791	1910	204/16
202/11	2639	1927	205/1
202/14	2742	1926	206/8
203/5	2921	1924	206/11
203/8	2994	1931	206/18
203/13	1712	1926	206/27
204/6	2161	1917	207/3
204/16	2027	1905	207/14
205/1	2884	1900	208/2
206/8	1040	1964	208/17
206/18	1859	1923	208/28
206/27	2388	1949	209/1
207/3	1770	1900	209/2
207/14	2082	1923	209/4
208/2	2476	1923	209/10

[#2]

@carmino 

In E2: =IFERROR(VLOOKUP(D2,$A$2:$C$25,2,FALSE),"")

In F2: =IFERROR(VLOOKUP(D2,$A$2:$C$25,3,FALSE),"")

If necessary, adjust the ranfge $A$2:$C$25.

Select E2:F2, then fill or copy downwards.

[#3]

@carmino 

As variant with dynamic arrays

with

=IF({1,0},
    FILTER(B2:B25,COUNTIF(D2:D25,A2:A25)),
    FILTER(C2:C25,COUNTIF(A2:A25,D2:D25))
)