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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You must log in or register to reply here.

Similar threads

D
  • Solved
Excel VBA for Changing Tab Name & Return Blank Cell to Formula
Replies
5
Views
129
DjTRex2002
D
M
  • Question
VLOOKUP help - return value if two partial matches are met (I think??)
Replies
5
Views
279
MountainFog
M
L
  • Question
Return text from cell in column containing text, as long as values in other columns match several criteria
Replies
7
Views
349
etaf
etaf
D
  • Solved
VBA check whether a row for the current date has been filled in and return yes/no value in another cell.
Replies
5
Views
193
mumps
mumps
A
  • Question
Vlookup formula to return specific text if cell contains match to list
Replies
3
Views
166
awoohaw
awoohaw

Forum statistics

Threads
1,214,635
Messages
6,120,660
Members
448,975
Latest member
sweeberry

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