Snasui Excel Forum

Hi There,

I need your help how to solve this
I have a result in the result sheet.
Here is a formula
=IF(Menu02!E15<>"",IF(AND(Menu02!B10="",Menu02!B15=""),VLOOKUP(Menu02!A10,Setting!A:E,4,FALSE),IF(Menu02!B10<>"",Menu02!F10&VLOOKUP(Menu02!A10,Setting!A:C,2,FALSE),IF(Menu02!B15<>"",Menu02!F15&VLOOKUP(Menu02!A15,Setting!E:H,3,FALSE),Menu02!F10&VLOOKUP(Menu02!A10,Setting!A:C,2,FALSE)))),"")

Thanks

Please attach file and point to your expected result.

Kindly take a look

For more clarification of an expected Result,I add more file to clear the output in SeeingJV tab
So if the values of Principal&Accrued Exp&Txa exist so it would come as per below:
USD170130001
USD170230001
PL64023
USD172260001
850000000028
...
and so one base on value of yellow cells

Best wishes

Sorry. I can't understand your requirement.

I mean that in Menu02 if value of Accrued exp,principal and tax store value it should
Listing down as below
USD170130001
USD170230001
PL64023
USD172260001
850000000028
The formula in attached file in SettingJV

Best wishes,

sna wrote: Sat Oct 10, 2020 4:29 pm The formula in attached file in SettingJV

Your formula has difference of each cell. You must explain all conditions you use instead, please don't explain with formula.