Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
worksheet.Range["L8"].Formula = "=VLOOKUP(K8,B4:E13,4,FALSE)"; As mentioned earlier, VLOOKUP can only search data vertically from the leftmost column. Similarly, for horizontal data, you can use the HLOOKUP (short for Horizontal Lookup) function that searches data in the first row. However, both of