Excel

Regular Visitor

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/LDBSq. Ft.DBYr BuiltGSB/L
102/227421929102/7
102/523411952104/3
104/228131926104/13
104/320071926106/11
104/737991911201/3
104/1320591965201/15
106/1425961920203/5
107/1521921880203/13
201/316401951204/6
201/1327911910204/16
202/1126391927205/1
202/1427421926206/8
203/529211924206/11
203/829941931206/18
203/1317121926206/27
204/621611917207/3
204/1620271905207/14
205/128841900208/2
206/810401964208/17
206/1818591923208/28
206/2723881949209/1
207/317701900209/2
207/1420821923209/4
208/224761923209/10

 

2 Replies

@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.

@carmino 

As variant with dynamic arrays

image.png

with

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