Hi All,
I Dont think I have the syntax right..here is what am trying, If the result
of the Lookup is "Extended" and the subsequent look-up outputs are between
1 to 5 should show as R, between 5 to 7 as Y and >8 as G Or If the Lookup
value is "Monthly" and the subsequent look-up outputs are 1=R, 2=
Hi Krishna,
Works Perfectly Fine:)
Thanks a ton.
Cheers
Shyam
On 8 May 2012 19:14, Krishna Kumar wrote:
> Hi
>
> Try
>
>
> =LOOKUP(2,1/(({"High";"High";"High";"Medium";"Medium";"Medium";"Low";"Low";"Low"}=F5)*({"High";"Medium";"Low";"High";"Medium";"Low";"High";"Medium";"Low"}=G5)),{1;2;1;1;2
-- Forwarded message --
From: Anera Shyam
Date: 8 May 2012 18:52
Subject: Re: $$Excel-Macros$$ Need macro to verify part numbers between 2
sheets
To: excel-macros@googlegroups.com
Hi All,
I wish to seek your assistance in getting the output as mentioned in the
attached excel
Hi All,
I wish to seek your assistance in getting the output as mentioned in the
attached excel cell:
for Eg:
If the Frequency is "High" and the Probability is also "High" I need to get
an output of "1"
like wise if Frequency is High and Probability is "Medium", I should get an
output of "2".
T
