|The previous response (from Humar) worked a treat, albeit with a few minor modifications that they wouldn't have know about...|
I have stumbled on a slightly different (one-off) issue now, where I need to be able to to get the user's name from their nickname, but I can't get the VLOOKUP to work properly. I can get it to bring up their username if I put their username (not very useful) and I can get their nickname if I put in their username, but I'm trying to use get the username from the nickname.....and that's in both GoogleDocs and Excel..
Columns are as follows, just to save confusion:
Monthly sheet, where the formula will be:
Name | Nickname
Main sheet, where the master list of users is:
[blank] | Name | Nickname
So far, the closest I have been able to get, in my Excel test spreadie is:
[[B7 = random user's name, result: same user's name - in this example, that is User7]]
[[B9 = random user's name, result: same user's nickname - in this example, that is also User7]]
Unfortunately those don't work, but it is at least a little more useful than the result of either of the following formulae - which just bring up "#N/A":
[[B6 = random user's nickname - in this example, that is Nick3]]
[[B8 = random user's nickname - in this example, that is Nick3]]
I did try to make the search area wider, to try to get it to pick up the correct column, but that just seems to have thrown an error straight off the bat..
From this VLOOKUP example page ( http://office.microsoft.com/en-us/e... ) I'm trying to get the formula in Column A to pick up the adjacent cell's entry (Column B) and find it in the other sheet, then give me the correlating Username for that....but I can't manage to tweak the formula/e to get it to work..
Anyone here have any suggestions..?