View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Saxman Saxman is offline
external usenet poster
 
Posts: 111
Default Impossible Task?

Marcelo wrote:

use a auxiliar table when you have

1 6
2 5
3 4
4 3
5 .5
etc

use a vlookup to find the answer

so in B1 you use =vlookup(a1,h1:i10,2,false)


Thanks, but where do I place the auxiliar table?