Vlookup

 Example:

=VLOOKUP(F2, $A$2:$A$130, 1, FALSE)

single line IF statemt

 Ex:

 var vchr1099Xml = (eVoucherType == "Voucher Maintenance" ? "" : VoucherMapper.ConvertVchr1099ToXml(new Vchr1099 { Flag1099 = "N", Amount = e3EVoucher.voucher.Amount }));