VBA or Excel - if cell BEGINS with a specific word return a corresponding value

M

MLSMITH1313

New Member
Joined
Jul 27, 2023
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I am needing to find out if a cell (in the data photo) BEGINS with a specific list of words(begins with photo). If it does, then I need it to return the value (return column) associated with that word in the OUTPUT.

1690464480453.png



1690464202678.png
 

Attachments

  • 1690464223569.png
    1690464223569.png
    4.3 KB · Views: 3
  • 1690464398262.png
    1690464398262.png
    4.3 KB · Views: 3

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

N
  • Question
VBA Help Required - Copy / paste text and photos to new file maintaining aspect ratio
Replies
0
Views
188
NeoSez
N
dcofer
  • Solved
Locating Words With Specific Letters in a Column
Replies
5
Views
277
dcofer
dcofer
U
  • Question
How to using Function on VBA
Replies
1
Views
185
upl365
U
S
  • Question
Issues with using Searching, Filtering, Indexing, and Matches containing Partial Text
Replies
2
Views
263
Steve454463
S
L
  • Question
Find text within a cell using formula
Replies
9
Views
433
Fluff
Fluff

Forum statistics

Threads
1,216,799
Messages
6,132,770
Members
449,760
Latest member
letonuslepus

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