How about:
=VLOOKUP(B2,SHEET2!A1:A100,2,FALSE)
Let me know if that works
How about:
=VLOOKUP(B2,SHEET2!A1:A100,2,FALSE)
Let me know if that works
Due to the values needing to be in ascending order I do believe that is the reason that the Vlookup function will not work in the scenero. Both Sheet 1 & Sheet 2 are not in ascending order based off the information in Column B in Sheet 1 and Column A in Sheet 2.
Last edited by JustMe602; 06-01-2007 at 10:18 AM.
It is possible that your lookup range and lookup array are not the same format. If you post a sample of your workbook, it will be easier to specify the problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks