If/Then Statements

[borleano]

Hello all,

Please allow me to apologize in advance if I break any forum rules or forum etiquette. I'm not a regular user or poster.

I'm trying to create a table/formula that can be applied to a spreadsheet I use several times a week. The spreadsheet is downloaded from an online app from my company (it's different every time). In a nutshell, it's the locations of each of my employees and where they have logged in.

I can see the store number, presented like WM856 or WM1340, but I need to know an additional piece of information that is not available on the spreadsheet. It is a number that I'd assign based on what's found in that column.

So, I'd like to create a formula that says if you find any of these values (WM856, WM1340, WM722, etc... (there are a possible 25 of them), then assign a number in another column. So, if you see WM856 or WM722 or WM1488 and so on, then place a 22. There are three different numbers I'd like to place based on which of the 25 store numbers might be found.

Thanks in advance for any insight into my question.

[alansidman]

Build a table with the 25 values in another sheet. In the column to the right put the number 22 or whatever number you want for the 25 values

In the sheet you are downloading, add a column adjacent column. Use the vlookup in that column to return the assigned values from the second column in the table you created.

Here is the syntax for vlookup. http://www.techonthenet.com/excel/formulas/vlookup.php

[abousetta]

You can use a simple vlookup. I created a thread a while back with several advanced options for vlookup that you might also want to look at.

Hope this helps.

abousetta