Lookups
Excel ยป Basic formulas ยป Lookups ยป
Column B contains document names, many of them are duplicates. The adjacent column C has the revision of the documents [โฆ]
The formula in cell D3 lets you get the last value in column B, it works fine with blank cells [โฆ]
Find last matching value in an unsorted list
I read an interesting blog post Find Last Item in Group With Index Match written by Debra Dalgleish. It is about [โฆ]
Lookup with an unknown number of criteria
Rashid asks:I used your array formula with great success to find the search results from multiple criteria. However, my problem [โฆ]
Find entry based on conditions
Bill Truax asks: Hello Oscar, I am building a spreadsheet for tracking calls for my local fire department. I have a [โฆ]
Formula in B14: =INDEX(D3:D6, SUMPRODUCT(--(C10=B3:B6), --(C11=C3:C6), ROW(D3:D6)-MIN(ROW(D3:D6))+1)) Alternative array formula #1 in B15: =INDEX(D3:D6, MATCH(C10&"-"&C11, B3:B6&"-"&C3:C6, 0)) Alternative array formula [โฆ]
How to perform a two-dimensional lookup
Question: How would I go about looking up data in a cross-reference table. I have the header row (i.e. 24) [โฆ]
Table of Contents Find closest value Find closest values Find closest values and return adjacent values Find closest value with [โฆ]
English
Spanish
