Please review the attached spreadsheet. I am using a simple LOOKUP formula in R1 - U15, that looks for team members on teams in Column P. Note that the teams that start with 1 (i.e. 1, 10, 11, 12, etc.) all reference Team 1. How can I get them to reference correctly?
Thank you for your help!
Hi Niester Rabbit,
When using the LOOKUP function, the values (i.e. Column A) must be in ascending order. As such you can either:
1. Change all the teams to 2 digits i.e. TEAM 01, TEAM 02 ... TEAM 99 and sort by Column A,
2. Sort your existing data in ascending sequence by Column A, or
3. Use the VLOOKUP function instead.
HTH
Robert
Last edited by Trebor76; 07-20-2008 at 09:36 PM.
This does help! I ended up going with VLOOKUP and used FALSE at the end, and that returned what I needed. Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks