Search specific string of word from a cell

[Riderboy5877]

Hi All,

I Need your Help on lookin up a specific set of alpha numeric unique ID from a cell which will have this Unique ID along with other words.

Corrected Example File attached.

Am sorry i put my query incorrectly previously

Below is what am looking for

Brief description of the Report:
Column A2 to Column C4 is system generated report and Column G2 to G4 is manually captured by user which may or may not have a space or alphanumeric before and after the Unique ID that they capture. This is were am facing issue to look up on user captured data against system generated report to get costing and volume accordingly.

Help needed:
What am lookin at is in Cell H2 we need to look up or search or match the Unique ID that's available in A2 to A4 to G2 once we are able to match this then need to look up for corresponding costing and Volume.

Thank You
Sudhir

[AliGW]

Welcome to the forum.

In B2 copied down:

=VLOOKUP(A2&"*",$G$2:$H$4,2,0)

In C2 copied down:

=VLOOKUP(A2&"*",$G$2:$I$4,3,0)

[Riderboy5877]

Hi AliGW,

Thank you so much for your response and really sorry i had put a wrong Question so i had to change it to correct one and also tried to be as descriptive as i could be.

[AliGW]

In H2 copied across and down:

=IFERROR(LOOKUP(1000,SEARCH($A$2:$A$4,$G2),B$2:B$4),"")

[Hans8]

Hello,

I hope I'm posting in the right thread, if not correct me please.

I'm looking for the n'th sign in a string, in this particular case the sign '-'.

Thanks for the help!

Regards
Hans

[Glenn Kennedy]

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!


The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.

[Riderboy5877]

Thank You so much AliGW. your solution worked like a charm

One last Query can we get the result as Blank only if any cell in B or C is also blank coz now it would return with a Zero 0.

Thank You.

[AliGW]

Yep:

=IFERROR(1/(1/LOOKUP(1000,SEARCH($A$2:$A$4,$G2),B$2:B$4)),"")

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Riderboy5877]

Thank You So Much