Blogs about: Vlookup
Featured Blog
Mike and Bill Debate: “=LOOKUP vs. @LOOKUP”
Going back to “VLOOKUP WEEK 2012” Mike ‘ExcelisFun’ Girvin and Bill ‘MrExcel’ Jelen look at the ‘LOOKUP’ Function. Taking cues from an email Bill received from Dan Bricklin [co-founder/inventor of Vis… more →
VLOOKUP WEEK
My first data journalism post: Vlookup
wrote 10 hours ago: I am a newbie when it comes to data journalism, excel and numbers in general. When playing around wi … more →
The School Office: Week 5
— 2 comments
wrote 5 days ago: It’s been fairly quiet in the office this week, with exams going on around school and the seni … more →
Introducing VLOOKUP & College Education Value
wrote 1 week ago: A good friend introduced me to a site by Payscale that compares the “value” of a college … more →
Tutorial for Excel VLOOKUP funtion
wrote 1 week ago: This is a video tutorial on how to use the VLOOKUP function in Excel. Hopefully I have managed to st … more →
Vlookup with multiple criteria
wrote 1 week ago: Although it does have some drawbacks, VLOOKUP is a useful function. One useful way of using it, is w … more →
Departmental Database
wrote 2 weeks ago: KS4 template It’s that time of the year again… when I revisit the Departmental Database … more →
Network Data from Unix to Excel: Count Next Hop IPs in Routing Table (Part 4)
— 2 comments
wrote 2 weeks ago: Today I present something very useful, which you might even use someday. I will be counting number o … more →
FAQ: How can I merge data from two databases?
wrote 4 weeks ago: In many cases you need to use multiple databases to gather the data you need, for example ExecuComp … more →
VLOOKUP in Excel
wrote 4 weeks ago: In Excel vlookup stands for Vertical Lookup. I think it’s one of the most useful tools Excel has to … more →
Do your job efficiently and have time for a break with VLOOKUP
wrote 1 month ago: I have provided extensive training for some employees at my office. During training to gear up for … more →
Excel 2010 vLookUp Tutorial for HR Practitioners
wrote 1 month ago: I guess like alot of people I spend some time on youtube, viewing inspirational videos and some pret … more →
Why I make an awful face when you use VLookup.
— 1 comment
wrote 1 month ago: Being a backseat driver while someone else is coding is painful. I get this overwhelming urge to yan … more →
Learn Excel 2013 - "VLOOKUP to Another Sheet": Podcast #1673
wrote 1 month ago: On one Worksheet we have Item Number, Date and Quantity; on another Worksheet – our LOOKUP Tab … more →
Software tools and HR
wrote 2 months ago: In the past I worked with an organisation that had an unofficial HR slogan of ‘great decisions … more →
Quick Post about Excel and HR
wrote 2 months ago: Hi team, Like many of us I was wondering through the video files of YouTube, and came across this ge … more →
Excel - VLookUp Formulas
wrote 2 months ago: Happy Saturday! I thought I’d follow up to the Excel Pivot Table lesson, with a lesson on ho … more →
Rumus Excel
wrote 2 months ago: Hai temans semua, saya dapat ilmu baru tentang per excel an, mau kasih informasinya ketemans semua ^ … more →
Lookups - VLOOKUP() HLOOKUP()
— 6 comments
wrote 2 months ago: The question… How do I lookup the values from a table to use in another table? This is actuall … more →
SpeedTools AVLOOKUP2 & MEMLOOKUP versus VLOOKUP - Performance, Power and Ease-of-Use Shootout Part 2
— 3 comments
wrote 2 months ago: In part 1 I looked at how FastExcel SpeedTools MEMLOOKUP and AVLOOKUP2 compared to VLOOKUP and INDEX … more →
