Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Just point the vlookup to lookup C2:C21 instead of D2:D21. C2:C21 contains
the numbers in alignment. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "maperalia" wrote in message ... Max' Thanks very much. I set up the function and the formulas in the way you advised me. It is working perfectly. However, when I want the result (D2:D21) to be read as number to vlookup from another column just the number without text is read the rest not. Can you help me please? Thanks. Maperalia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort by column problems | Excel Worksheet Functions | |||
Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions | |||
How to sort but keep linked formulas? | Excel Discussion (Misc queries) | |||
How do I format a column in alpha order? | New Users to Excel | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |