Can some one help me with simple formula to do below job for me?
I have 2 work sheets
Work sheet name : Claims. This has columns A till I
How to populate I2 value
When Cell A2 has value "Krish" or "Jacks", We need to apply below formula in I2
Take cell H2 value in this Claims work sheet, Compare with cell A1 value in another work sheet called Reference
If the values match, take C2 value in Reference work sheet and populate value in I2 of Claims work sheet
If the value does not match, populate as "Offshore" in I2 of Claims work sheet
When Cell A2 does not have value "Krish" or "Jacks", We need to mention "no match"
Bookmarks