Return single value on multipl criteria lookup
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
|