| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP?
I have a list of customers sites where each site has a unique number.
Against each of the numbers is the name of the site for example; 001 London 002 Oxford .. .. 1340 Birmingham 1341 Manchester etc. etc. These are listed in 2 columns on a hidden worksheet in a multi-page spreadsheet. What I would like to do is when the site number is input say in cell A1 on a different worksheet I need to automagically insert the site name that matches that particular site number. So in my example if I input 002 in cell A1 then Oxford appears in B1 I am guessing I need to use VLOOKUP or something but can some kind soul point me in the right direction please? -- Thanks & regards, -pp- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
