Results 1 to 11 of 11

finding or matching data

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    Wales
    MS-Off Ver
    office 2007/excel 2003
    Posts
    15

    finding or matching data

    Ok so this has been bugging me for a week or so and i have attempted many functions to no avail.

    My spreadsheet consists of two columns, column A holds a series of numbers whilst column B, again holds a series of numbers but with an added single letter on the end.

    What I would like to do is find a function which will match the numbers and letter in column B with the corresponding numbers in column A and then place the result in column C. eg

    A B C
    9111111 1234567H 9111111B
    6789109 4567888
    1234567 9111111B 1234567H

    Hope that make sense anyway.

    Any help on that would be great as I am not the greatest at functions.

    James
    Last edited by VBA Noob; 11-09-2008 at 12:36 PM.

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.6.0 RC 1