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 work for me
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 Regards,
Ravi
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 and
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 kartik.1...@gmail.com wrote:
Hi Ashwani,
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
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 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
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 below
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:RT)