You are here: HomeExcelTutorials

# Lookup a value in a table and return the value in the first cell of the row

## Lookup a value in a table and return the value in the first cell of the row

Price: FREE

So I am making a bowling stats spread sheet and am stuck with the last part of it. I need to look at all the scores of everyone in the league and return the persons name and score of the highest, 2nd highest, 3rd highest, and 4th highest for men and women
Right now I have the following times 10 teams
gender Team #1
m Jim 123 213 134
m Hank 166 11 215
m John 22 213 197
f Paula 100 145 98
f Jane 210 168 153
I have used the MAX formula to find the max value but cannot figure out how to display the name of the person who bowled that max value.

Visit publisher's web-site: Lookup a value in a table and return the value in the first cell of the row

Category and Tags: ExcelTutorials :

## Related Tutorials

### Trying to return value based on lookup in table

Free: Yes
Tags: Excel ›

It seems Excel has a limit on IF statements within IF statements so I need help with a more elegant solution!
I am trying to do what I would view as a VLOOKUP however it is looking up multiple values One of those I am looking for in the row labels along the left of the table and the other value I am looking for in the column labels along the top of the table. I am looking to return the value in the table that meets these two values and multiply it by another cell.
Also the value I am looking up will not be precise i.e. 22.05 however the row labels will be 20, 22.5, 25. etc.

### Row / Column lookup from table of data.

Free: Yes
Tags: Excel ›

fellow Excellences!
I've hit a stumbling block, I have a table of data and want to be able to lookup the highest 3 value and return corresponding dates and shift.
Please see attached sheets as to what I am trying to do!
I'm currently using the 'LARGE' formula to return the 3 highest values.

### VLOOKUP and LOOKUP

Free: Yes
Tags: Excel ›

Currently using the LOOKUP function ot return the last populated column cell in a row.
=LOOKUP(2,1/('Data Entry'!J7:BL7<>""),'Data Entry'!J7:BL7)
Is there a way to do this by building in a VLookup
For example if on Table 1
Cell A1 = Returns and I enter a formula into Cell B1 Referencing Table 2
The Formula will search through Table 2, find the row with Returns and return the last populated values for this?
Sorry for the lack of clarity, hard to explain

### Lookup value from row and return higher if not available

Free: Yes
Tags: Excel ›

Hopefully I can explain this but if an example sheet is need please let me know.
I have a value in cell A1, lets say "H"
I have a value in Cell A2, lets say 1100
I now have a range of A4:J15. Column A contains letters from A-L, the rest of the range contains numbers.
What I am trying to get is a formula that will take the value from cell A1 to find what row that is on and if the value in cell A2 is in that row then just return it otherwise if the value is not found then return round up to an available value in that row.
I have written this formula but it seems to round down rather than up.
=HLOOKUP(A2,\$B\$4:\$J\$15,MATCH(A1,\$A\$4:\$A\$15,0))

### (V)LOOKUP question

Free: Yes
Tags: Excel › Functions

A simple task that I just can't get to work.
I have a simple table in which I enter a number in a cell. I then
want to LOOKUP this number and if it matches what I am looking for I want to return "1" if not return "0"
eg
A B
using the above table I want to look up the numbers in column A in a separate table and if it in the lookup table, return "1" if not "0" the lookup table has
I got Vlookup to work but if the number is not in my lookup table I get an #N/A returned which I don't want
Any suggestions would be helpful or a better idea I'd br grateful

## Related Applications & Scripts

### SamMySql Database Class

Free: Yes
Tags: PHP › Excel Classes MySQL

This class wraps common MySQL database table SQL queries. It can:
- Perform SELECT queries and retrieve a single value, a single row into an array and all rows into a multidimensional array.
- Insert or update rows from a list of fields and values
- Delete table rows that satisfy a condition
- Count records in a given table
- Check if a table record exists with a given field value
- Perform a database search
- Return a certain number of rows of result from database, et

### DataTable or Data Grid

Display of data through DataTable facilitates data management: - The rows can be ordered by clicking on the header of the column that you wish to order by. - You can set your own table size: set width, height, or both. If you set the size, scrolling bars will be shown when the amount of data requires it. - For tables with a high number of rows: Rows can be separated in pages, thus allowing to move between pages; you can also change the amount of rows per page; - Each row in the table will show a column defined by user - either Delete the row, or Edit it. Packaged into a Dreamweaver extension. No hand coding needed.

Free: No
Tags: Flash › Excel Actionscript

The HTML Table Renderer component ( free download ) provides an advanced XML / HTML table rendering engine for Flash, complete with CSS support and advanced features such as row and column spans.
The component can render all common types of content (text, SWF files, images and Flash library objects) and allows embedding custom fonts and offers advanced text rendering controls.

### HTML Table Renderer AS 3.0

Free: No

The HTML Table Renderer component provides an advanced XML / HTML table rendering engine for Flash, complete with CSS support and advanced features such as row and column spans.
The component can render all common types of content (text, SWF files, images and Flash library objects) and allows embedding custom fonts and offers advanced text rendering controls.
This component is available for: Flash CS3/4, ActionScript 3.0

### Just Ajax Table

Free: No
Tags: Ajax › Excel PHP Table and Datagrids

JustAjaxTable performs all operation with tables "on-fly" using Ajax requests. It is an Ajax/PHP grid library that allows you to create web-based data grids/tables that behave like desktop software.
Features:
In-place cell editing, live scrolling, live sorting, PHP/MySQL backend, cross-browser support.