Closed Thread
Results 1 to 2 of 2

Request for helping the right formula creation

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    321

    Request for helping the right formula creation

    Please look the following datas:-

    Part No Description
    1100661 OIL ENGINE 10 W 30 - SJ GRADE
    31916-KST-920F SPARK PLUG
    91302-KEV-9000F O-RING 30.8X3
    95701-06110-00 BOLT FLANGE 6X110
    90081-GFP-9000F BOLT SOCKET FLANGE 6 X 23
    90701-GF6-0000 PIN DOWEL SPECIAL 8X14

    I want to know the part no.having end with "F" in a separate column.The expected result should be as:-

    31916-KST-920F
    91302-KEV-9000F
    90081-GFP-9000F

    I am applying the following formula:-

    Column C Column D
    *F IF(C3="","",INDEX($A:$A,MATCH(C3,A:A,0)))
    and the result is coming:-

    31916-KST-920F
    but when I copy the *F in C4 and the above formula in D4,the same result comes i.e.
    31916-KST-920F.It should come 91302-KEV-9000F in D4 cell and 90081-GFP-9000F in cell D5.Can you help me for the desired result achieve?

    Regards

    Pradeep

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Request for helping the right formula creation

    Pradeep, this is another invitation to read the forum rules and follow them!

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

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