Please condense the question to its simplest form - omit unneeded info (like
column e-h!)
Give an example of a typical row (not LINE)
Tell how the table if set out.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"maplesugarsnow" wrote in message
...
Hello,

I have a spreadsheet with three columns of data (A-"treaty", B-"AY",
C-"ASL") with 247 lines of combinations of these three fields. The fourth
column (D) needs to be what I call the "AU", which will be different based
on
the combination of the three data fields. Columns E-H contain financial
data. Worksheet 2 in the file lists the combinations where I can lookup
the
"AU" to be input to worksheet 1, column D but I don't know how to do a
look
up function that takes into account three criteria to determine one
response.
Can anyone assist with this? I would greatly appreciate it.

Thanks.
Deborah