View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kris
 
Posts: n/a
Default vlookup in several sheets

Hi
I want to make the range in my vlookup formula variable. If for example I
use the account from 2200 into 2300, I want the vlookup to change it's search
range automaticly to this new range
My formula is =vlookup(+c11;+c12;3;false) and c11=206 and c12=tabel2300
--
Greetz
Kris