Sounds like you should be using the V or H lookup function....

On Aug 14, 12:22 pm, wrote:
Hi,

Can anyone help me please with a data validation issue. I have a set
of Oracle Tables which are being used in a PeopleSoft Financials
system. There is a requirement to validate all data being input into
an Excel Spreadshet against these Oracle Tables. What would be the
best way of doing this? I have looked at the Data Validation option
within Excel but the volumes of data we are talking about here makes
it not possible.
It would also be nice to create a report (maybe txt file) showing
where, if any, there were errors

Any help would be gratefuly apprecitated.

Richard