QUESTION : I have a fuel consumption log, with vehicle id’s in column ‘C’ and fuel consumed and distance traveled […]
Tag: lookup
Excel: Finding a value in a range of values
QUESTION : In my Excel document, I have one sheet containing a column of important dates. In another sheet I […]
Excel – Lookup to match varying criteria
QUESTION : I have a list of poles, some with more than one test result. I want to find the […]
Checking if any cell in a column of strings on one worksheet is contained in a column of strings in another worksheet
QUESTION : I have a column of strings in an Excel worksheet. I’m looking for a way to write a […]
Match 5 closest in same array
QUESTION : I have a list of customers and lat/long coordinates (3 columns:c,u,v respectively) I want to create 5 columns […]
Find and return sheet name
QUESTION : I am looking for help in finding a string within a workbook and returning the sheet name (Address) […]
Map/Copy values from one sheet to another in excel if they match on column header
QUESTION : This post gets me very very close to where I need to be How can I copy a […]
Using AVERAGEIF() over a range of years
QUESTION : I have a dataset that includes year, country, and population data. A small condensed sample is below. I […]
Excel Lookup/Match exact match only
QUESTION : I am a bit confused with lookup/match and the lookup wizard in excel 07 does not seem to […]
MS Excel using multidimensional lookup
QUESTION : Hi am trying to assign a value given that if I have a some value that matches column […]
- 1
- 2