Hello friends,
I want to find the following result with IF formula. How to do it?
Value Result
Asalpur JGU
Khushkhera KGU
Sikandarabad UPGU
Udaipur Udasar SGU
I am trying to use the following formula but it is not working
=IF(C4="Asalpur",IF(C4="Khushkhera",IF(C4="Sikandarabad",IF(C4="Udaipur Udasar","SGU","UPGU"),"KGU"),"JGU"),"")
Bookmarks