Consulting

Results 1 to 4 of 4

Thread: Solved: If value in a row = value in another column store in another cell

  1. 05-17-2008, 02:33 AM #1
    rajesh nag
    rajesh nag is offline
    VBAX Regular
    Joined
    Nov 2007
    Posts
    43

    Solved: If value in a row = value in another column store in another cell

    HI,

    If the values in G2,H2,I2 = value in column C then store that value in K2.
    I tried Vlookup, Hlookup its not working for me.

    If attached the file for your referance.

    Regards,
    Rajesh
    Reply With Quote Reply With Quote
  2. 05-17-2008, 02:49 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    =IF(G2=C2,G2,IF(H2=C2,H2,IF(I2=C2,I2,"")))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 05-17-2008, 11:52 PM #3
    georgiboy
    georgiboy is offline
    Moderator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,197
    Location
    You could try something like this

    =IF(COUNTIF(C:C,G2),G2,IF(COUNTIF(C:C,H2),H2,IF(COUNTIF(C:C,I2),I2,"")))

    Hope this helps
    Reply With Quote Reply With Quote
  4. 05-18-2008, 05:23 AM #4
    rajesh nag
    rajesh nag is offline
    VBAX Regular
    Joined
    Nov 2007
    Posts
    43
    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules