Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Single statement database/range processing with criteria | Excel Worksheet Functions | |||
return value based on two criteria | Excel Worksheet Functions | |||
Return cell reference of lookup value | Excel Worksheet Functions | |||
Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
Return Multiple Results with Lookup | Excel Worksheet Functions |