Need a function that finds a value in a table range and returns the cell number

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

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
 
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 (e-mail address removed)
 
Back
Top