Skip to content
  • Qlikview
  • SQL Server
  • Power BI
  • Excel / VBA
  • About
  • Contact

BuffaloBI.com

Qlikview | SQL Server | Power BI | Excel

BuffaloBI.com

Excel VLOOKUP

Excel VLOOKUP – Approximate Match

October 10, 2017May 13, 2016 by bbiadmin

Excel’s VLOOKUP function is a very powerful tool that allows users to combine and match two columns in separate datasets.  When performing a VLOOKUP, a given value is matched in a separate range of values within a specific column, returning a value (the desired lookup value) specified in the column index of the row of the match.  The V in … Read more

Leave a comment

Excel VLOOKUP – EXACT Match

October 10, 2017April 26, 2016 by bbiadmin

Excel’s VLOOKUP function is a very powerful tool that allows users to combine and match two columns in separate datasets.  When performing a VLOOKUP, a given value is matched in a separate range of values within a specific column, returning a value (the desired lookup value) specified in the column index of the row of the match.  The V in … Read more

Leave a comment

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • Qlikview Export to Excel Part 1
  • Qlikview Dimension Background Color
  • Excel VBA Copy and Rename Files
  • Excel VBA List Files in Folders and Subfolders
  • SQL Take Database Offline Stuck
  • Excel VBA Copy and Rename Files in Folder and Subfolders
  • Excel VBA - Loop Worksheets
  • Qlikview Dimension Limit Based on Variable
  • Excel VBA Find File in Folder and Subfolders
  • Qlikview Max Number Straight Table Chart

Categories

Archives

February 2019
M T W T F S S
« Jan    
 123
45678910
11121314151617
18192021222324
25262728  

Tags

Action (2) Array (2) Button (2) CONCAT (3) Copy Range (2) Custom Sort (1) Cyclic Dimension Group (2) Excel (9) Excel Function (2) Excel VBA (24) Excel VLOOKUP (2) Expression (2) Fantasy Football (2) For Each Loop (4) INFORMATION_SCHEMA (2) List Box (4) Load Order (1) Macro (4) Original (1) Qlik (4) Qlikview (43) Qlikview Bundle Load (1) Qlikview Export to Excel (2) Qlikview Macro (5) Qlikview Select in Field (1) Qlikview Set Analysis (3) Qlikview Trellis Chart (1) Refresh (1) ROW_NUMBER (2) Select in Field (1) Show Frequency (3) Sort Order (1) SQL (26) SQL CHARINDEX (2) SQL HAVING (2) SQL Server (5) SubField (2) Table Box (2) Text Object (1) Transact SQL (3) Trellis Chart (1) TSQL (25) Variable (5) VBA (12) VBScript (4)

Recent Posts

  • Power BI Split Column By Delimiter
  • Excel VBA Copy and Rename Files in Folder and Subfolders
  • Excel VBA Count Character in Range
  • Qlikview Remove Unwanted Characters with PurgeChar Function
  • Excel VBA Alternate Row Colors

Pages

  • Excel / VBA
  • Power BI
  • Qlikview
  • SQL Server
  • BuffaloBI.com
  • Contact – BuffaloBI.com
© 2019 BuffaloBI.com • Powered by GeneratePress