View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Number Transformation

Hello,

Put into C1:D4
1 11
2 8
3 7
4 =A1

Then enter into B1
=VLOOKUP(A1,C1:D4,2,0)

Regards,
Bernd