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?