in cell c3 add this formula and fill down
=IF(UPPER(VLOOKUP(A3,E:F,2,0))<>UPPER(B3),"Error","")
see if it helps
On Sat, Sep 7, 2013 at 11:07 AM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Hi,
>>
>
> I just realized that if i can search the values of table 2 in table 1 it
> will
>
> Hi,
>
I just realized that if i can search the values of table 2 in table 1 it
will work for me i am not concerned with status now .. for ex...i want to
search all the values( 121, 123, 124 ) present table 2 in table 1
...please let me know the formula
Regards,
Ashwani
--
Are you =EXP(E:R
Hi,
Provide the example output.
** * Best Regards,
Ms Excel User
*
**
On Fri, Sep 6, 2013 at 9:07 PM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Hi Kartik,
>
>
>
> Thanks for looking into this. The result is still not what I want. I have
> tried to explain it
Hi Kartik,
Thanks for looking into this. The result is still not what I want. I have
tried to explain it below
Table 1
Table 2
*ID*
*Status*
*ID*
*status*
121 =
active
121=
*Ok*
123=
active
123=
Ok
124=
active
124=
Ok
125=
active
126=
active
So if ID 121 =active (statu
Please find attachment, hope this is the result you are looking for. If i
understood wrongly please let me know in breif
Regards,
Kartik
On Fri, Sep 6, 2013 at 3:19 PM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Thanks for reply guys , but the output I was looking was that if the
Hi,
Can someone please help me with this?
Regards,
Ashwani
On Fri, Sep 6, 2013 at 3:19 PM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Thanks for reply guys , but the output I was looking was that if the lookup
> table has ID 121 with Status as “ Ok” but in original table ID 121
Thanks for reply guys , but the output I was looking was that if the lookup
table has ID 121 with Status as “ Ok” but in original table ID 121 status
is “active” so I should come to know of the mismatch
On Fri, Sep 6, 2013 at 1:01 PM, Kartik Dale wrote:
> Hi Ashwani,
>
> Please find attachment.
Hi Ashwani,
Please find attachment. Just drag the formula in F column if you need it.
Regards,
Kartik
On Fri, Sep 6, 2013 at 11:03 AM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Hi,
>
> I have a query. I have two table named original and other.
>
> Now I want to look up for ID,s
Hi,
Try this..
Sub lookupconfirm()
Range("F3").Formula = "=IFERROR(IF(VLOOKUP(E3,A3:A7,1,0)>0,""OK""),""Not
OK"")"
Range("F3").Copy
Range("F3:F" & Cells(Rows.Count, 5).End(xlUp).Row).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
Warm
