I need to take the sum of value 2 devided by sum of value 1 only if the mapping has "Y" for instrument using vlookup formula.
Instrument Value 1 Value 2 Mapping
XS1117297 2,000,000.00 1,915,000
XS1117297 -500,000.00 -478,125 Y
XS1117297 -200,000.00 -192,000 Y
XS1017435 -1,254,000.00 -1,279,080
XS1017435 250,000.00 261,250
XS1017435 -250,000.00 -261,488 y
XS1017435 250,000.00 260,325 y
XS1017435 -250,000.00 -260,250 y
Expected result should be as follows.
XS1117297 0.957321429
XS1017435 1.04565
Bookmarks