Tag: table
-
VLOOKUP: Right to Left Lookup
We all now know that VLOOKUP has one major constraint that the column in the lookup table from where the lookup value is to be searched should be the first column in the lookup table. Here is a tricky way that you can use to overcome this constraint. The trick…
-
Introduction to VLOOKUP in MS Excel
Hi friends… one of the important features of Excel which every user of Excel is expected to be aware of, is VLOOKUP function. Here I take you through the nuts and bolts of VLOOKUP: What does VLOOKUP do ? VLOOKUP function looks up (searches) a value in one column and…
-
Single T-SQL query to swapping the values of two columns without using temporary column
How to swap the values of two columns of a table ? Let me explain the scenario with an example – Let’s create a table named “Employees” with columns “First_Name” and “Last_Name”. Then populate the table with some fictitious data. Then view the results once and then interchange the values in…