Thread: dynamic PROCV
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default dynamic PROCV

Ninho wrote...
I need to use the PROCV function as following:
cell 1 - type of product [name of cell group]; cell 2 - one number;
and the function should be:
=PROCV(cell 2;cell1;x;FALSE)
but the cell1 string is denied. Is there a soluction? 'Cause this two
info are not constant.


I'm guessing that PROCV is the Portuguese language version equivalent
of the English language version's VLOOKUP function. Looks like the
English language version formula you're after is

=VLOOKUP(cell2,INDIRECT(cell1),x,0)

Up to you to translate these. Also, you find it expedient to post in
Portuguese language Excel newsgroups.