lookup value and return value in cell

[djsouljah]

Hi Team,

I need the vba code for the following;

Lookup value in me.textbox1 and search for it in Sheet 'Evaluation Tracker" in range CG1:CG20000 and return the value that's in that same row range A..

Can you please help me out with this one..

Thanks

[venkatpvc]

will this help you?

Please Login or Register  to view this content.

[djsouljah]

thanks Sorry I forgot to mention it needs to return the value in sheet "Quality Grid" Range A4 and i have multiple values to return not just the value in column A

ps: right now it's returning the value I have in textbox in the sheet quality grid A4...it's supposed to find the value in enterred in textbox in column CG in sheet evaluation tracker and return the value that's on the column A of that same row it find the value

[venkatpvc]

may this below

Please Login or Register  to view this content.

if this above macro did not get what you need please upload workbook with sample data, it will be eaiser for you and me to get desired results.

[venkatpvc]

may this below

Please Login or Register  to view this content.

if this above macro did not get what you need please upload workbook with sample data, it will be eaiser for you and me to get desired results.

[djsouljah]

Thanks Man! Works great..

Got a question for you..

I need to have a message box if the value is not found after the search in evaluation tracker..

How to I insert that in the code?

Right now if I enter a number that doesn't exist it give me the error "Runtime error 91" Object Variable or With block variable not set