Advanced VLOOKUP Cheat Sheet Thumb

Advanced VLOOKUP Cheat Sheet

We have now reached the end of the Mastering VLOOKUP series.  Hopefully, you’ve picked up a few tips and tricks to take your VLOOKUP skills to the next level.  If you’ve been following along you will have learned more than just VLOOKUP: Faster calculation from an approximate match – this also applies to HLOOKUP and Read More

VLOOKUP Automatically Expend Data Range Thumb

Automatically expand the VLOOKUP data range

The 2nd argument in the VLOOKUP function is the table_array.  This is the range of cells which contains the data to be used within the VLOOKUP function.    For example, in the code below A1:C9 is the table_array. =VLOOKUP(“O Redding”,A1:C9,3,FALSE) When using the VLOOKUP function, we often know how many rows there are in the data, Read More

VLOOKUP-change-column-automatically-thumb

VLOOKUP: Change the column number automatically

Unfortunately, VLOOKUP, whilst powerful, simple and easy to use, is one of the least flexible functions in Excel.  Just imagine for a moment that we have entered the following formula into Cell E6 (see screenshot below). =VLOOKUP(E4,A2:B10,2,0) This formula is returning the value from the 2nd column (Column B) – result 21. But, what happens Read More