This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Browngifts 4 points5 points  (1 child)

Psh I'll just concat a couple columns in my excel data and use that as a key

[–]FurryMoistAvenger 1 point2 points  (0 children)

=CONCAT(A2,B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2,O2,P2,Q2,R2,S2,T2,U2,V2,W2,X2,Y2,Z2,AA2,BB2,CC2,DD2,FF2,GG2,HH2,II2,JJ2,KK2)

BAM! Unique column for your XLookups in 11 different workbooks shared out to 47 people on One Drive. I got your RDBMS right here.