Thread: Need a function that finds a value in a table range and returns the cell number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_4_] Alan Beban[_4_] is offline
external usenet poster
  
Posts: 171
Default 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

Reply With QuoteReply With Quote