Your use of the CHOOSE formula here is absolutely obsolete.
Having CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9) is equivalent
to simply using RATESHEET!$B$6:$C$9
Instead, you could have passed the column number dynamically by looking
were the CR COIL is located. For this you could have m
Dear Raghu,
You can use..
=VLOOKUP($G$2,CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9),2,0)
See attached sheet..
On Sat, Feb 4, 2012 at 12:02 AM, raghu gr wrote:
> Hi experts,
>
> I have a invoice file and summary file, i want the formula in rate column,
> which has to pick from rate
Thank you sir, its working
with regards
raghu
On Mon, Feb 6, 2012 at 8:20 PM, The Viper wrote:
> check the attachment and go to rate sheet
>
>
> On Sun, Feb 5, 2012 at 2:13 PM, raghu gr wrote:
>
>> hi,
>>
>> Thanks a lot sir,
>>
>> For the same type of file i tried to write formula in the atta
hi
check the attachment
On Sat, Feb 4, 2012 at 12:02 AM, raghu gr wrote:
> Hi experts,
>
> I have a invoice file and summary file, i want the formula in rate column,
> which has to pick from rate sheet.
> please help me in this regard
>
> Attached sample file
>
> Thank you
>
> with regards
>
Hi experts,
I have a invoice file and summary file, i want the formula in rate column,
which has to pick from rate sheet.
please help me in this regard
Attached sample file
Thank you
with regards
Raghu
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
