Find specific text in column and return cell value from its immediate right

**cneff** · 02-21-2012, 02:57 AM

Hi Everyone,

I am trying to get a cells value to return to a textbox in a userform

example

Textbox1 contains "Bob"

I want it to search worksheet 3 and column A

If "Bob" is found lets say in A7 then I want it to return the value from B7 to Textbox2

any Ideas?

many thanks in advance

**TMS** · 02-21-2012, 04:21 AM

You would typically use VLOOKUP to return a value from a corresponding cell, that is, find a match in column A, return the value from column B.

So, use Textbox1 as the lookup value and columns A and B as the search range and return column 2 (B) to Textbox2. The last parameter to the VLOOKUP is FALSE.

Regards, TMS

**cneff** · 02-22-2012, 09:03 PM

I am not sure How I would put that into VBA code..

any suggestions?

Chris

**jaslake** · 02-24-2012, 02:58 PM

Hi Chris
Here's an example

Please Login or Register  to view this content.

**abousetta** · 02-24-2012, 03:21 PM

If its all in one column, you could probably just use vlookup.

Please Login or Register  to view this content.

**TMS** · 02-24-2012, 03:38 PM

@abousetta: think you might need the fourth parameter: FALSE

Regards, TMS

**abousetta** · 02-24-2012, 03:56 PM

Thanks TMS. I usually remember that... I have updated the formula above but don't have time to test it right now (at work).

**abousetta** · 02-24-2012, 05:39 PM

OK. Got a chance to test it now and made a minor correction to the code in post #5.

**abousetta** · 03-08-2012, 07:59 AM

Hi,

If you are satisfied with the responses, then please mark the thread as Solved (instructions in the Forum Rules and FAQs).

Good luck.

abousetta