Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. Thank's -- Alea jacta est! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Formula with Dynamic Address | Excel Worksheet Functions | |||
Make dynamic charts more dynamic | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions |