| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP in VBA
Lance Hebert" wrote:
There will be a very large list of name, utlimately. Where could I go to get assistance with that type of VBA code? Thanks for the help. "Sean Timmons" wrote: That would depend on how many people you'd be assigning. you can use If...Then =IF(AND(E2="X",J2="Y"),"Sue","Bob") Or perhaps... =IF(AND(E2="X",J2="Y"),"Sue",IF(AND(OR(E2="Z",E2=" N"),J2="Y"),"Bob","Charles") You can nest several If statements, but if you're looking at a lot of names, you'd want to look at doing Visual Basic code and a Select...Case... "Lance Hebert" wrote: I have a spreadsheet, which is shared on a network that has a number of columns in it and a very large list of entries. I want to be able to add a column that would look at a couple of the columns within each row and determine, based on more criteria, who would be assigned to that particular line. I would like the column to add the name of the person assigned based on two other pieces of information in the column. Here is the information: Columns A-M, where Column E (Area) and Column J (Type) would be needed to determine who would be assigned to this line. I know how to setup a VLOOKUP for one item and attach a name to it from another sheet/tab, but how do I make it so it would be similar to: If Column E is ... and Column J is ..., or ..., or .... than, Sue is assigned. Any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| Vlookup problem - unable to get the vlookup property | Excel Programming | |||
| using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
![Lance Hebert[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
