Billy Ma
asked on
Excel Look Up Problem
I have a list of orders and a class for list of orders
for simplicity, I have put every in a single worksheet, in real, I have million of such records.
I want to look up the class for each order in Microsoft Excel.
I tried to use VLOOKUP function but it doesn't work.
Hope someone can help!
Thanks!
Orders.xls
for simplicity, I have put every in a single worksheet, in real, I have million of such records.
I want to look up the class for each order in Microsoft Excel.
I tried to use VLOOKUP function but it doesn't work.
Hope someone can help!
Thanks!
Orders.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Of course I know. that's why I want to ask if any method I can perform this without need to manually change the content