Conditional Vertical Lookup

S

soconfused

I am trying to write a functional statement that picks up a certain value on
a different worksheet.

If the first 4 letters of this column in this sheet equals this, insert H-
in this cell.
 
S

soconfused

Mike,

I don't think I posed my question properly.

I have two work sheets and the first column of the 2nd worksheet has all the
combinations of parts that I need. On the first sheet in column C are part
numbers. I have to look at the 2nd sheet to see what kind of part it is and
insert a single letter in the first worksheet in column C.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Page numbering with Merged Document and IF statements 1
Conditional Formatting to Another Cell 0
Conditional Formatting Amendment 2
Merging from an Excel file with graphics 1
Drop down list control value in vba 2
Sub projects added as read only in Master file which are saved on sharepoint 1
Function or Sub to help with text string 5

Top