| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Activate Vlookup Function?
"ViestaWu" wrote:
Thanks so much Max. I tried =vlookup(a2&"", sheet2!A:B,2,FALSE), and it works. Glad it worked. So the reason is, though I set it as text, excel can't recognize it, unless I alter it to text obligated, right? Yes, numbers being matched need to be consistent: either text vs text, or real vs real (lookup values vs lookup col in table _array) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pastable function using VLOOKUP? | Excel Worksheet Functions | |||
| Vlookup worksheet function | Excel Worksheet Functions | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| Vlookup w/Date Function | Excel Worksheet Functions | |||
| Regarding IF function or vLOOKUP function | Excel Worksheet Functions | |||
Threaded Mode
