| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup database
Hi,
I have a database S = 5 UM = 4 MM = 3 LM = 2 J = 1 I have a list of people that i have ranked A B Jenny S Max J In Column C I would like the numerical equivalent of the letter ranking. ie. Jenny is 5 and Max is 1 Is there a simpler approach than an embedded if statement? I have many more ranks that I have list here and embedded ifs are not that practical. Any help appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Lookup information in Access Database | Excel Discussion (Misc queries) | |||
| How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
| Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
| Database Lookup | Excel Worksheet Functions | |||
Threaded Mode
