I have a table - I would like excel to look down a particular column and across a particular row and find the cross reference...
For example,
If the value in column N = 4, select from that row
Then look at value in cell AG1. Find that along row 4 and return cell that meet both criteria.
There has to be a way to do this in excel... can anyone assist?
Thanks in advance!
Bookmarks