## advanced vlookup (like)

i think it should be done with match vlookup and offset but its too complicated. i need to show differences between revenues of client between 2016 month five …

## 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 …

## Expiration Dates

Hi, thank you very much for your help. I have in about 30 worksheets in 1 workbook. In each worksheet-cell B3, I have expiration dates for materials. I …

## complicated if function

Dear Excelgeek, I need your help to make formula for my study, here is the result table: Male Result Age Very Good Good Fair Poor Very Poor 10 …

## 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 …

## Find cell value in matrix and return the value below

Jag letar efter ett sätt att hitta ett unikt värde i en matris och sedan returnera värdet i raden under det. Column 1 Clumn 2 Column 3 Bird …

## Marketing Intelligence

I’m doing a VLOOKUP to find a value. On the following column, I need to find the value immediately below the one that VLOOKUP got. How would I go about …

## Comparing Data with Excel

Hello, I have two Excel sheets, each one contains ID and Quantity. I want to automate the task of comparing the two quantities together for the same ID. …

## Vlookup or if

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–> up front/ annually quarterly/monthly $1,000 $4,999 5% …

## How to sum multiple rows and columns

Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …

## If/Vlookup Help?

Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following: There could be 2 rows …

## SUM formulas

I’m wanting to add up a row of values that are pulled from a vlookup in another spreadsheet. Some of these values will result in a blank because …

## VLOOKUP & IF OR MATCH/INDEX

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be …

## Get vlookup to recognize 102A as a lookup value

I’m using vlookup to populate a tally spreadsheet. It is working very well when the lookup value is a regular number – like 21073 (classified …

## Fleet report manager

I use a software that is online to track my companies fleet. I am creating reports in excel for things like fuel consumption. I download the spreadsheet …

## Updating Pricing Question

Hi, I am tryign to combine a VLOOKUP function and an IF statement. Basically I want to quality check pricing for a product using an ID number, so do a …

## Sumif or Vlookup based on several criteria

Hi … using Excel 2010 I’m looking to get a sum of 5 different numbers referenced by “codes”, and wondering if there is an easy way to …

## if with two vlookups doesn’t work

Hi guys, Really desperate for your help here. Can’t get my head around why this formula does not work. Im using excel 2002 and trying to used If with …