If Then Text Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of customer numbers and serial numbers. I need a formula that will find the customer number in a list, then fill the cell with the serial number (contains alpha and numeric characters, ie BBB1001).

Example: If the value in cell A2 is equal to 1234, then find 1234 in a range (B2:B100), and retrive the serial number in a range (C2:C100).

Thank you for your help.
 
You must log in or register to reply here.

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

Another VB Code Required 7
Using SUMIF with AND 2
Vlookups and formats 3
Help with Conditional Formatting 5
two sets of variables to find result 3
index/match, based on more than one criteria 2
If cell not empty, then display from range 7
Autofilter - display column showing visible row count 5

Back
Top