Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2071646%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071646%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20please%20help%3F%20Col%20A%2C%20B%2C%20C%2C%20contain%20public%20information%20from%20a%3CBR%20%2F%3Edata%20base%20I%20frequently%20use.%20I%20want%20to%20match%20Col%20D%20to%20Col%20A%20and%20extract%20the%3CBR%20%2F%3Evalue%20of%20DBSqFt%20and%20DBYrBuilt.%20Let%20me%20thank%20you%20in%20advance%20since%20I%20don%E2%80%99t%20know%3CBR%20%2F%3EIf%20I%E2%80%99ll%20know%20how%20to%20after%20you%20respond.%20My%20email%20is%20carmino%40netzero.net.%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3ECarmen%3C%2FP%3E%3CTABLE%20width%3D%22339%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22108%22%3ENJACTBB%2FL%3C%2FTD%3E%3CTD%20width%3D%2289%22%3EDBSq.%20Ft.%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EDBYr%20Built%3C%2FTD%3E%3CTD%20width%3D%2278%22%3EGSB%2FL%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E102%2F2%3C%2FTD%3E%3CTD%3E2742%3C%2FTD%3E%3CTD%3E1929%3C%2FTD%3E%3CTD%3E102%2F7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E102%2F5%3C%2FTD%3E%3CTD%3E2341%3C%2FTD%3E%3CTD%3E1952%3C%2FTD%3E%3CTD%3E104%2F3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E104%2F2%3C%2FTD%3E%3CTD%3E2813%3C%2FTD%3E%3CTD%3E1926%3C%2FTD%3E%3CTD%3E104%2F13%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E104%2F3%3C%2FTD%3E%3CTD%3E2007%3C%2FTD%3E%3CTD%3E1926%3C%2FTD%3E%3CTD%3E106%2F11%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E104%2F7%3C%2FTD%3E%3CTD%3E3799%3C%2FTD%3E%3CTD%3E1911%3C%2FTD%3E%3CTD%3E201%2F3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E104%2F13%3C%2FTD%3E%3CTD%3E2059%3C%2FTD%3E%3CTD%3E1965%3C%2FTD%3E%3CTD%3E201%2F15%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E106%2F14%3C%2FTD%3E%3CTD%3E2596%3C%2FTD%3E%3CTD%3E1920%3C%2FTD%3E%3CTD%3E203%2F5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E107%2F15%3C%2FTD%3E%3CTD%3E2192%3C%2FTD%3E%3CTD%3E1880%3C%2FTD%3E%3CTD%3E203%2F13%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E201%2F3%3C%2FTD%3E%3CTD%3E1640%3C%2FTD%3E%3CTD%3E1951%3C%2FTD%3E%3CTD%3E204%2F6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E201%2F13%3C%2FTD%3E%3CTD%3E2791%3C%2FTD%3E%3CTD%3E1910%3C%2FTD%3E%3CTD%3E204%2F16%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E202%2F11%3C%2FTD%3E%3CTD%3E2639%3C%2FTD%3E%3CTD%3E1927%3C%2FTD%3E%3CTD%3E205%2F1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E202%2F14%3C%2FTD%3E%3CTD%3E2742%3C%2FTD%3E%3CTD%3E1926%3C%2FTD%3E%3CTD%3E206%2F8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E203%2F5%3C%2FTD%3E%3CTD%3E2921%3C%2FTD%3E%3CTD%3E1924%3C%2FTD%3E%3CTD%3E206%2F11%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E203%2F8%3C%2FTD%3E%3CTD%3E2994%3C%2FTD%3E%3CTD%3E1931%3C%2FTD%3E%3CTD%3E206%2F18%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E203%2F13%3C%2FTD%3E%3CTD%3E1712%3C%2FTD%3E%3CTD%3E1926%3C%2FTD%3E%3CTD%3E206%2F27%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E204%2F6%3C%2FTD%3E%3CTD%3E2161%3C%2FTD%3E%3CTD%3E1917%3C%2FTD%3E%3CTD%3E207%2F3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E204%2F16%3C%2FTD%3E%3CTD%3E2027%3C%2FTD%3E%3CTD%3E1905%3C%2FTD%3E%3CTD%3E207%2F14%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E205%2F1%3C%2FTD%3E%3CTD%3E2884%3C%2FTD%3E%3CTD%3E1900%3C%2FTD%3E%3CTD%3E208%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E206%2F8%3C%2FTD%3E%3CTD%3E1040%3C%2FTD%3E%3CTD%3E1964%3C%2FTD%3E%3CTD%3E208%2F17%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E206%2F18%3C%2FTD%3E%3CTD%3E1859%3C%2FTD%3E%3CTD%3E1923%3C%2FTD%3E%3CTD%3E208%2F28%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E206%2F27%3C%2FTD%3E%3CTD%3E2388%3C%2FTD%3E%3CTD%3E1949%3C%2FTD%3E%3CTD%3E209%2F1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E207%2F3%3C%2FTD%3E%3CTD%3E1770%3C%2FTD%3E%3CTD%3E1900%3C%2FTD%3E%3CTD%3E209%2F2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E207%2F14%3C%2FTD%3E%3CTD%3E2082%3C%2FTD%3E%3CTD%3E1923%3C%2FTD%3E%3CTD%3E209%2F4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E208%2F2%3C%2FTD%3E%3CTD%3E2476%3C%2FTD%3E%3CTD%3E1923%3C%2FTD%3E%3CTD%3E209%2F10%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2071646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2071990%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071990%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F799277%22%20target%3D%22_blank%22%3E%40carmino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20E2%3A%20%3DIFERROR(VLOOKUP(D2%2C%24A%242%3A%24C%2425%2C2%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3EIn%20F2%3A%20%3DIFERROR(VLOOKUP(D2%2C%24A%242%3A%24C%2425%2C3%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20necessary%2C%20adjust%20the%20ranfge%20%24A%242%3A%24C%2425.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20E2%3AF2%2C%20then%20fill%20or%20copy%20downwards.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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))
)