I enter "PRT01194" into B4, I need "CtrSt 1BL3 North" to appear in A4. Thanks

[NBie]

The process...

I get an email from a printer (PRTxxxxx).
I then enter PRTxxxxx into column "B".
I then seach Column "I" for the printer.
When I find the printer in column "I", I enter the value from the corresponding row of column "J" into Column "A" next to where I entered the PRTxxxx.

For example, I enter PRT01194 into B4. I want a formula in A4 that searches Column I for the text PRT01194. When it finds it in I128, I want A4 to display J128 "CtrSt 1BL3 North."


I'm not particularly attached to this spreadsheet method, so If you need to move things around, I don't mind, so long as when I enter PRTxxxxx I get the value from the J column that corresponds with the I column.

If you have questions let me know. Thank you.

[tlafferty]

See attached. Note that you are asking to strip out some text, but it won't be consistent. The formula in the attached workbook doesn't strip text out but gives the exact match, if found, from the I column.

[Fettertiger]

Hi Nbie,

this is the classical situation for the Vlookup formula:
In B4 you need to enter the following formula:
=VLOOKUP(B4,I:J,2,;0)

As a Result B4 will now have the correct value. Of cause you can simply copy the formula "down" and you will have all values for all printers.

Regards

Theo
__________________
Please consider:

Thanking those who helped you. Click the scales icon in the upper right corner of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

[NBie]

That worked perfectly, thanks for your efforts.

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save