Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table / Range Unions

Status
Not open for further replies.
sabascal

sabascal

IS-IT--Management
Aug 20, 2002
85
0
0
GB
All,
I remember to have read somewhere that it was possible to create Union of arrays. I can't figure out how to do that.
Given A1 , and A2 two distinct arrays I would like to be able to do a VLOOKUP on UNION(A1, A2).
Any body that could help?
Thanks,
Seb
 
Sort by date Sort by votes
create Union of arrays
NO, Union of ranges

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
137
remeng
remeng
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
223
SkipVought
S
MattGreer
  • Locked
  • Question
Delete a Table Row in a Filtered Table 2
Replies
11
Views
253
SkipVought
S
arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
74
arvarr
arvarr
M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
132
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top