VBA to return vlookup value and clear

Z

Zimmerman

Well-known Member
Joined
Jan 22, 2009
Messages
663
I'm sure this is pretty easy but for some reason I can't figure it out. I have a sheet that the user types in cell B3. Cell I27 is a vlookup for what the user types in. If the lookup value returns the word "RITZCRAFT" I would like to call userform1. If it returns anything else I would like to clear the contents in cell H29. Also would need this to avoid any errors. Meaning if the return value comes back as nothing because it's not found I'd like to not have a run time error.

Thanks in advance
excel 2016
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
You must log in or register to reply here.

Similar threads

K
  • Question
Return a user specified number of cell values to a comma list randomly
Replies
1
Views
96
Eric W
Eric W
H
  • Solved
Using Macro/VLOOKUP to return format of cell
Replies
9
Views
168
mumps
mumps
E
  • Solved
This one is tricky. VLookup but return a different cell value
Replies
6
Views
247
Alex Blakenburg
A
D
  • Solved
Excel VBA for Changing Tab Name & Return Blank Cell to Formula
Replies
5
Views
158
DjTRex2002
D
M
  • Question
VLOOKUP help - return value if two partial matches are met (I think??)
Replies
5
Views
345
MountainFog
M

Forum statistics

Threads
1,215,373
Messages
6,124,551
Members
449,170
Latest member
Gkiller

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top