Top "Vlookup" questions

VLOOKUP is a Spreadsheet function for retrieving a value from an array using a vertical lookup value and a positive column offset.

Unable to lookup a date using vba vlookup

I have an excel worksheet with column A containing dates and column B containing the respective days. Eg. A2=01/01/14 and …

Read More
excel vlookup vba
Filling down a VLOOKUP formula without changing the range

I am comparing values in a row in one sheet to values in another row in another sheet. The following …

Read More
excel excel-formula vlookup worksheet-function
UDF to remove special characters, punctuation & spaces within a cell to create unique key for Vlookups

I hacked together the following User Defined Function in VBA that allows me to remove certain non-text characters from any …

Read More
vba excel vlookup excel-udf
Excel VLOOKUP between two sheets failing

I am trying to copy data from column E (cost) in sheet1 where the value in column A (code) in …

Read More
excel vlookup
Excel - Recursive VLookup

I recently came to know about Ctrl+Shift+Enter array formulas of Excel and currently still learning them. Coming to …

Read More
excel excel-2007 worksheet-function vlookup
Concatenate multiple results from an index match

I'm trying to concat multiple results from an index match into one cell. Here is an example data set I'm …

Read More
excel excel-formula vlookup string-concatenation textjoin
Nested If statement Excel - checking if value exists

I have a spreadsheet with multiple row with varying data in the collumns eg: Student NO Book1 Book 2 Book 3 Book 4 …

Read More
excel vlookup nested-if
Excel VBA VLookup on a tables second column

Just trying to see if its possible to use VLookup on the second column of a table? I have searched …

Read More
vba excel vlookup