Hello:
In the attached excel file, result is required in "Sheet1" tab, column G based on combination of data available in columns A, C, D, and E. The data will be fetched from "lsspecific" tab.
Please see below example from line item 1 in the, excel sheet.
1: Event date is 1/1/2020, so formula must search in "lsspecific" tab, A and B columns for date range.
2: RS is 997, so formula must search in "lsspecific" tab, C column.
3: LS is SELF, so formula must search in "lsspecific" tab, D column.
4: Amount is 250000, so formula must search in "lsspecific" tab, E and F columns for amount range.
Result will be the value from coumn G in "lsspecific" tab
Thanks in advance for all the help.
Bookmarks