QUESTION : I have a cell which does a vlookup. But the table to which it refers is always changing […]

# Tag: vlookup

## Excel – Look up on multiple tables – complex

QUESTION : I am trying to make it so that my operators can cut and paste information into an Excel […]

## Excel Formula CONTAINS

QUESTION : I need a formula that will look for a specific text in a cell that is also referenced […]

## What Excel formula to use?

QUESTION : I ONLY have 2 column which is the “date” and “number”. I really don’t know how to explain […]

## Excel table conversion help needed

QUESTION : Here is the current table: I would like it to look like this: As you can see in […]

## Lookup based on three criteria

QUESTION : I have this sheet. I want to lookup the value of Execution (%) based on three criteria: Year, […]

## how to concatenate the output of vlookups in one step

QUESTION : I’m trying to run two vlookup operations and concatenate the results in one formula as such: =CONCATENATE( VLOOKUP($A$6,’TRP’!$A$7:$D$655,2,FALSE), […]

## Build a lookup query in Excel using named ranges stored in a cell

QUESTION : I have a spreadsheet which has a lot of named ranges, each of which is a table. I […]

## Excel does pallet X in location Y physically match the system

QUESTION : I’m trying to physically validate pallet id’s and locations compared to what our system indicates. There are two […]

## Vlookup using wildcards in indexed column

QUESTION : I know how to use a wildcard with Vlookup on the reference value, but what about on the […]