Any Ideas?
 

I have a workbook that picks up results from a .txt file and puts the
in a report. The problem I have is that the database creating th
results is in an development stage and through-out this development
have a select number of queries to check the results with. At presen
I'm checking the results by glancing over each one and comparin
results. I need something that will do this checking automatically an
flag up any problems. Not too bothered about details but has anyon
done something similar or have an idea about the best way to go abou
it?

cheer

--
Jimbo
-----------------------------------------------------------------------
Jimbo1's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=53454

Any Ideas?
 

Yes,
I do something similar with txt files.
For statistical data...
I use VLOOKUP, HLOOKUP and variable IF statements on different programs.
CHECK THIS OUT!!!:
http://www.rondebruin.nl/id.htm
Download the Excel Function Dictionary
at the very bottom of the page!!!!!



Feature names in COlA
Nominal In col B
USL in Col C
LSL in Col D
Actual value in column E

..=VLOOKUP(STATS!A1,A1:E321,5,TRUE)

From the site:
What Does It Do ?
This function scans down the row headings at the side of a table to find a
specified item.
When the item is found, it then scans across to pick a cell entry.

Syntax
..=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFr om,SortedOrUnsorted)
The ItemToFind is a single item specified by the user.
The RangeToLookIn is the range of data with the row headings at the left
hand side.
The ColumnToPickFrom is how far across the table the function should look to
pick from.
The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes,
FALSE for no.