| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup help (I think)
I am constatly entering client numbers and names in an excel
spreadsheet. What i would like to do it have a fomula in column b that will return the client name that i type in column a. I could have a master list of client to lookup from. Can someone please help me with this. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup help (I think)
Create a list of numbers and names in M1:N20 say and use
=VLOOKUP(A2,$M$1:$N$20,2,False) adjust the last row to suit. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ups.com... I am constatly entering client numbers and names in an excel spreadsheet. What i would like to do it have a fomula in column b that will return the client name that i type in column a. I could have a master list of client to lookup from. Can someone please help me with this. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup help (I think)
I'm confused, You type a name in Col B and if a match exists in Column A,
what is it you want to do? Mike " wrote: I am constatly entering client numbers and names in an excel spreadsheet. What i would like to do it have a fomula in column b that will return the client name that i type in column a. I could have a master list of client to lookup from. Can someone please help me with this. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Linear Mode
