View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default How do I create a function to search a range for a number and...

You can use the VLOOKUP function to do this. See help for more
details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com






"NECCExcel" wrote in
message
...
then return the value of the cell next to that number to a
given cell?