Thanks, Its working fine.
On Thu, Mar 4, 2010 at 8:41 PM, ashish koul wrote:
> see the attachment r u looking for this but for that u need to create that
> temp col in sheet1
>
> On Thu, Mar 4, 2010 at 8:14 PM, Puttu wrote:
>
>> Hello Team,
>>
>> I need a formula or VB macro where as I have t
see the attachment r u looking for this but for that u need to create that
temp col in sheet1
On Thu, Mar 4, 2010 at 8:14 PM, Puttu wrote:
> Hello Team,
>
> I need a formula or VB macro where as I have two different sheets with
> Same data, when it match the result should show in other sheet nex
Are you wanting to check to see if the "XX Name" field matches?
or just to see if the XX # is present?
If you're just checking for XX #, then,
you can use the ISNA function with the VLOOKUP function
(if vlookup doesn't find anything, it returns #N/A, ISNA tests to see if it is
N/A.
so, if your d
