Afternoon all

I have a large (200 Meg) xml (database-like) file that I would like to use as a big lookup table.

Excel may not be the perfect tool for this but is it possible to search for one (or more than one) value(s) in an element. The xml file is pretty flat with a number of single and repeating elements:

database
doc
daterev
daterev
ident
desc
sy
sy
sy
mp
tox
tox
doc

From the tree above I would like to search on the ident and return the desc and all the tox.

Bob