Macro that will look for decription in other tab

[geliedee]

Hi all,

I have here a file. I want a macro that will look for the description from the inputted value in Column C, D, E in the RAW tab. If i click the run macro button it will all appear.
The description will be on the next tab.

I want it to be a macro since the lines is more than 100k.

Please find the attached file. Appreciate your kindness on helping me.

[Vikas_Gautam]

I think there is no need of macro.. as there is only one row matching your result..
Give a try to the attached file and tell is that what you were trying to achieve..

Please Login or Register  to view this content.

[geliedee]

Hi, file you have attached is not worrking. i want this as macro coz it will be applied also in other files.

[oeldere]

Please Login or Register  to view this content.

Can you explain why the file is not working?

I expect the solution in the added by Vikas_Gautam will do as you requested.

[sktneer]

Please find the attached sheet to see if this is what you are trying to achieve. Click the Green Button on Sheet1 to get the desired output in Col. I, J and K based on the criteria in Col. C, D and E.

[Vikas_Gautam]

@oeldere
Thanks for endorsing my solution oeldere ..
I think there is no need of macro...

@OP
If you insist on using macro solution..
I thinks Sktneer's solution will do the job..

i want this as macro coz it will be applied also in other files.

is not a valid reason as you can copy and paste my formula ... if your all files have same standard formats...

[geliedee]

Book1_ geliedee.xlsmHI SKTNEER,

once i entered other values in column C, D and E its not showing the description on the column I, J, K.

[geliedee]

This file will be populated by more than 100k lines...

[sktneer]

You should input the matching values in col. C, D and E. You entered 165 while it should be 162 as there is no match for clerk 42 with credit rep group 165. Moreover you were entering Industry in lower case so I have modified the code to take care of it.
See the attached.

[geliedee]

Hi,

Its working as long as it is in the same row.
What i want it will show the description as long as it the can be find on the next sheet.
So what ever i enter in Column C D and E the description will show.

Appreciate what you did.
Thank you so much and i hope youc an help me one last time

[sktneer]

Please find the attached sheet to see if this works as per your requirement now.

[geliedee]

hello sktneer, i just saw the file and its working fine. I was on leave. Thank you so much! But how would i add a status column? It the 3 columns match it should appear in the status column to proceed.

Please see this picture: Status is on column M.
Capture.JPG

The problem here is they have different meaning/ But if accounting clerk column, credit rep and industry has the same one word it should appear proceed.

[sktneer]

What do you want in status column? Run the code with some values in cols. C, D and E and then show me (upload the workbook not image) what are you expecting in the status column and why? i.e. what is the logic behind the status column as you said if the three columns match, which are those columns?

[geliedee]

Hello sktneer,

What i want for the status column M is to show ALIGNED if the Column I, J and K have the same description.
for example:
I J K M
Lubes Oil Blending - FP1 Lubes Oil Blending P Lubes Oil Blending P ALIGNED
SD Supply - FP1 SD Supply DE_Lubes Consumer Di MISALIGNED

For example column I, J and K has different descrption right? But its all for the Lubes. there fore they are still aligned with each other.
In the second exmaple, Column K is different from I and J coz its for LUBES. There fore, they are misaligned.

i have attached the sample workbook.
Apolgies if i cant explain well.. Thank yu ur a great help

[geliedee]

also if column C D and E is blank, it will not proceed. Thanks sktneer..

[sktneer]

Please find the attached sheet to see if this works as per your requirement.

[geliedee]

Perfect!!! Omg! Youre my saver~ thanks so

[geliedee]

One last question Sktneer, regarding this file.

if the column C, D and E are blanks it should show a msgbox that theres no data. else, it will run.
Thanks!!

[sktneer]

You're welcome and thanks for the feedback.
Please find the attached sheet to see it this meets your new requirement.

Moreover if that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

[geliedee]

Hi again.

I have modified the file, i mean i put designs and everything.
But the code youi gave doesnt work on my file. can you please put the updated codes in this file? so i can mark the thread solve. Thanks so much..

[sktneer]

What changes you have made to your workbook and in which sheet? The workbook what you have attached here is password protected and I can see only one sheet and in this sheet I can see that you have changed the row number of columns headers. Have you made any changes to the other sheet also.
Please upload the unprotected workbook.

[geliedee]

I have added rows. In the previous file, headers are on the celll A2 to M2. Now its on cell A4 to M4. Thats just the difference... i have attached the unprotected file. apologies..

[sktneer]

Please find the attached sheet. I have also deleted the conditional formatting for column M to make the cell highlight red if it contains the word Misaligned.
Now the code will highlight any cell in col. M if it contains the word Misaligned.

[geliedee]

Wow!!! Thats what exaclty i need!! Thank you so much!!

[sktneer]

You're welcome.