You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.

I have a .net project using SQL Server backend that I'm looking at localising. Handling localisation within .net is straightforward enough, got it managing the views, data annotations, messages etc.

I'm trying to convert what was a Select Case to a Lookup Table. The Select Case was roughly 60K lines, so 30K of lookups (Int32, String). The problem is the editor is DAMNED SLOW. Every time I make an ...