View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MESTRELLA29[_2_] MESTRELLA29[_2_] is offline
external usenet poster
 
Posts: 34
Default Vlookup question

I have a Formula

Dec (name range) the following table
1 5000 30%
5001 10000 40%
10001 19999 50%

D9 = 10,000
=VLOOKUP(D9,dec,1) this returns the value 5001

I need to update "Dec" to "jan" By change A Cell, how can i do that?

GRACIAS