The MATCH() command produces a row number. Is there a way to use that row number to reference a cell? For example, instead of typing A3 can you type the A and use the match commmand to be the 3? I tried using ADDRESS() at first but for some reason I could not get that command to work. If I can figure out this problem my entire spreadsheet will work.
Bookmarks