There is no direct vlookup function in SQL server, but to be honest, vlookup is a difficult way to do it anyway.
If you use the examples in this vlookup page:
http://www.techonthenet.com/excel/formulas/vlookup.php[
^]
Then the SQL equivalent would be:
SELECT Product FROM pvtTable WHERE OrderID=10251
SELECT UnitPrice FROM pvtTable WHERE OrderID=10251
SELECT Product FROM pvtTable WHERE OrderID=10248
The final one would return no records.