+ Reply to Thread
Results 1 to 2 of 2

Thread: Search and display data in excel 2007

  1. #1
    Registered User
    Join Date
    11-01-2011
    Location
    Delhi, India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Search and display data in excel 2007

    Hello All,

    Can anyone help me to perform the following action in excel 2007

    Search a string in column A, which contains set of text data, and than display that string to next column B or C or D, if found,

    With vlookup, match, etc I am able to find the string value but unable to display them as described above.

    TIA
    Nick

  2. #2
    Forum Guru Domski's Avatar
    Join Date
    12-14-2009
    MS-Off Ver
    What does it matter?
    Posts
    3,933

    Re: Search and display data in excel 2007

    What's the vlookup formula you were using? A sample workbook showing the desired result would probably be useful.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0