View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Impossible Task?

doesn't matter, you can put it in any place of your spreadsheet, in may
sample, I put it on h1:i10 range


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Saxman" escreveu:

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?