You can change as follows :-
=ROUND(VLOOKUP(F3:F1000,$I$3:$J$100,2,0)*(1+($J$1/100)),0)
Regards
Pravin Gunjal.
-- Forwarded message --
From: SAJID MEMON
Date: Tue, Aug 6, 2013 at 2:10 PM
Subject: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ???
To: Sundarvelan Natarajan
Dear Friends,
It is possible to lookup the values for the left side and second value,
third value
Is their any other ways or functions to get the results.?
1. Shall we can get the left side result by using vlookup function?
2. Shall we can get the second value result by using vlookup function
Dear friends,
Good afternoon,
I need a help and I want to know how to use vlookup function by using match
and columns function. How it is works?
Plz, share with me.
*1.This is using match function*
=vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match
type),*range lookup).
*2
Hi Sreejith,
Attached is another excel sheet with total region wise sales and also the
employee wise (both conditions fulfilled at same point).
Thanks & Regards
Santosh Kumar Subudhi
-- Forwarded message --
From: santosh subudhi
Date: Sun, Jul 8, 2012 at 9:43 PM
Subject: RE: $$E
Dear all,
any help possible on mentioned subject?
Thanks
Regards,
Hemant
-- Forwarded message --
From: Hems
Date: Sun, Mar 13, 2011 at 12:35 AM
Subject: $$Excel-Macros$$ Vlookup in master file through Macro
To: excel-macros@googlegroups.com
Dear All,
I want to update the s
Dear all,
This is urgent to me, plz suggest solution as early as possible.
Warm Regards,
Muralidhar E.
-- Forwarded message --
From: muralidhar e
Date: Thu, Nov 11, 2010 at 11:02 AM
Subject: $$Excel-Macros$$ Vlookup
To: excel-macros@googlegroups.com
Dear all group members,
