Ok I need help ASAP if possible, please!!
I have to lookup based on username (column B) in one file, but return the corresponding sector for that person from another spreadsheet. The user name in this spreadsheet can be found in Column C, but the value I need to have returned is the sector which can be found in column V of the same spreadsheet.
How can I get this to work?! I'm in great need of help! Thanks in advance!!
I have to lookup based on username (column B) in one file, but return the corresponding sector for that person from another spreadsheet. The user name in this spreadsheet can be found in Column C, but the value I need to have returned is the sector which can be found in column V of the same spreadsheet.
How can I get this to work?! I'm in great need of help! Thanks in advance!!