Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lynn Lynn is offline
external usenet poster
 
Posts: 131
Default VLOOKUP

Have this function

Look up value : A3
Table Array: '01'!Q:S
Column Index Number:2
Range Look Up: False

Want to copy formula into other column
Not change Lookupvalue:A3
Change Table Array:02 and keeping adding for example column D=01. E=02,F=03
not change in table array Q:S
How can I do this?



--
Thanks
Lynn