Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel help
Hi, I am currently working on a project where in calculations are performed in excel:- Requirement Based on country in dropdown list,the target level in the perfscore sheet will be multiplied by matrix .Please help. Not able to attach the excel -- anoopbitsmart |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel help
You wll probably need VLOOKUP to return the corresponding value from
the country, although it might be an INDEX/MATCH combination, depending on how your data is laid out. Please give more details. Pete On Mar 10, 4:21*pm, anoopbitsmart <anoopbitsmart. wrote: Hi, I am currently working on a project where in calculations are performed in excel:- Requirement Based on country in dropdown list,the target level in the perfscore sheet will be multiplied by matrix .Please help. Not able to attach the excel -- anoopbitsmart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|