## LOOKUP Functions

-Do exact match lookup and approximate lookup use different functions? (Is it true or false?: Exact match lookup and approximate lookup use different …

## LOOKUP, IF formula problem

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula: …

## FORMULA HELP COMPARING TWO COLUMNS OF DATA THAT ARE NOT AN EXACT MATCH

Hello, If anyone could help me with this, I would greatly appreciate it. I am looking for a formula that will help me with the following situation.  I …

## VLOOKUP lookup_value number not changing

=VLOOKUP(1,’Main Tracker’!A:F,6,FALSE)   When I copy this formula down, I want the lookup_value, the “1”, to fill series so when I …

## Using reverse partial lookup with look up value that contains of two keywords

<!–table {mso-displayed-decimal-separator:”.”; mso-displayed-thousand-separator:”,”;} @page {margin:.75in .7in .75in .7in; …

## Which is the best function

I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index.  For the …

## Looking up text in string

Need to consolidate or look up which client deposited funds to our account. On our BANK DATA we see the account number or a reference from whom the transfer is …

## IF cell contains text with nest

How do I write the following in VBA?   If (“F2”) begins with 8:     true: if (“H2”) is empty       …

## Daily Balance Sheet

I need a workbook to keep up with cash paid out and received daily. I would like to have multiple sheets for each month (example – dec. 1st, dec. 2nd, …

## Excel Function to insert a value from a range of cells if the same value is entered in a named cell

Hi there, I’m trying to put in a function that will return a value from a range of cells when I put a related value in another cell. In column A I have a …

## Vlookup with Today() formula

The first table is the input table.  The second table is the for the results. The result should display as follow:  – If the end date of the …

## Combining lookup with matrix

Hi all,   I’m looking for a solution to my excel problem. I’m not sure whether this can be done by using formulas solely, I hope it can be …

## Formula to Associate Number to Name in another sheet

I have a sheet (Contacts) with my customer contacts in it and a separate sheet (Customers) with my customer companies in it.  The “Contacts” …

## Return multiple values based on single criteria

Hi,  Let’s say I have this data set: Name First Trait Second Trait Third Trait Fourth Trait Fifth Trait Alison Learner Restorative Relator Arranger …

## 3 condition lookup (or index&match)

Hi, can someone help me with this problem i have. On a source table i have something like this:   m1 m2 m3 a 31-Dec 39 75 64 a 10-Jan 28 48 87 a 20-Jan 71 …

## Which formula should I use?

I’m working with about 4,000 names and zip codes of local volunteers on our registry. I need to sort them into specific jurisdictions based on their zip …