Thank you
@sahil_raina_91 for the solution..
I need one more help
I have PLANT in Col B, REVAL IN LC in Col V, REVAL USD in Col W.
Now I want to calculate REVAL USD for all PLANTs.
For Plants 5100,5120,5400,5420,5619, REVAL USD= REVAL IN LC / 4-----(REVAL IN LC divided by 4)
For all other Plants ,REVAL USD= REVAL IN LC
For your information, I have many plants other than 5100,5120,5400,5420,5619 in the PLANTS (Col B)
What is the VLOOKUP formula for this scenario?
Thanks in Advance