Most welcome amar.
Regards
Prince
On Friday, January 4, 2013 11:05:00 AM UTC+5:30, amar takale wrote:
>
> Hi Prince,
> Really Great formula
> Thanks a lot
>
> Regards
> Amar
>
> On Fri, Jan 4, 2013 at 10:39 AM, Prince
> > wrote:
>
>> =IF(ISERROR( IF(ISERROR(
>> VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0
Hi Prince,
Really Great formula
Thanks a lot
Regards
Amar
On Fri, Jan 4, 2013 at 10:39 AM, Prince wrote:
> =IF(ISERROR( IF(ISERROR(
> VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0))/K6),"",IF(ISERROR(
> VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F
Hi Amar,
Just Paste the following formula in I6 Cell and Drag up to data I26.
=IF(ISERROR( IF(ISERROR(
VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0))/K6),"",IF(ISERROR(
VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0))/K6)
Regards
Prince
Ignore the last one
PFA
On Thursday, January 3, 2013 6:28:42 PM UTC+5:30, harshad shukla wrote:
>
> dear Sir,
> please find attached file.
> In this I have to collect the value of supplier based on item code.
> For any single item code there can be two or more vendors.I want to get
> the qty. su
HI harshad ,
PFA.
Regards
Prince
On Thursday, January 3, 2013 6:28:42 PM UTC+5:30, harshad shukla wrote:
>
> dear Sir,
> please find attached file.
> In this I have to collect the value of supplier based on item code.
> For any single item code there can be two or more vendors.I want to get
> t
Dear,
PFA, Solved
Thanks & Regards,
Prajakt Pande
+971551388482
**
On Thu, Jan 3, 2013 at 4:58 PM, harshad shukla
wrote:
> dear Sir,
> please find attached file.
> In this I have to collect the value of supplier based on item code.
> For any single item code there can be two or more vendors.I
dear Sir,
please find attached file.
In this I have to collect the value of supplier based on item code.
For any single item code there can be two or more vendors.I want to get the
qty. supplied by each by using VLOOKUP.For any further clarification you
can give a miss call on my number mentioned b
Hi harshad,
May be this link help you for applying vlookup. It contains tutorial with
pictures
http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel
Video tutorial
http://www.youtube.com/watch?v=HjRjRnzy-hA
Regards,
Lalit Mohan
On Thursday, 3 January 2013 16:09:23 UTC+5:3
Can you please share ur wbk or can explain the senario through an example.
Regards
Prince
On Thursday, January 3, 2013 4:09:23 PM UTC+5:30, harshad shukla wrote:
>
> Dear all.
> I was stuck up while using vlookup on two parameters.please help.
> Urgent requirement.
> Harshad Shukla
>
--
Join of