I have a spreadsheet like this:
So, I know on SheetName, row 1 has my manager needed, so I need to find their value of the Function in that sheet and put it in this current sheet, row E. This address formula isn't working. How do I get it to work? The 1 in column D above is calculated with the following formula:
=MATCH(C2208,'SheetName'!$D$2:$D$25,0) //this returns row that the manager in C2208 is found in SheetName.
My original idea was to do this with vlookup but I couldn't figure out how to get vlookup to work.
Bookmarks