| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a function that finds a value in a table range and returns the cell number
HI, i need a function that finds a value in a table range and returns
the next cell value. For example Got this list A B C 1 RED 120 2 BLUE 10 3 BLACK 230 4 PINK 330 5 WHITE 500 6 If want to find black...so the function should return 230. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a function that finds a value in a table range and returnsthe cell number
=VLOOKUP("BLACK",A1:B5, 2,FALSE)
Alan Beban Tony wrote: HI, i need a function that finds a value in a table range and returns the next cell value. For example Got this list A B C 1 RED 120 2 BLUE 10 3 BLACK 230 4 PINK 330 5 WHITE 500 6 If want to find black...so the function should return 230. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a function that finds a value in a table range and returns the cell number
Tony,
Use the VLOOKUP function. For example, =VLOOKUP("Black",A1:B10,2,FALSE) See help for more details about VLOOKUP. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tony" wrote in message om... HI, i need a function that finds a value in a table range and returns the next cell value. For example Got this list A B C 1 RED 120 2 BLUE 10 3 BLACK 230 4 PINK 330 5 WHITE 500 6 If want to find black...so the function should return 230. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to put worksheet name in cell returns text, need number | Excel Discussion (Misc queries) | |||
| Function that returns the page number a cell falls on | Excel Worksheet Functions | |||
| Need a formula that finds the last used cell in a range | Excel Worksheet Functions | |||
| Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
| Which @function finds the mean of a number? | Excel Worksheet Functions | |||
Linear Mode
