Hi, i have to get a lookup value from a table using 2 values.....
imagine the table has values down the vertical column 1-10, and then across the top a-j, with all the data i need in the table between.....how would i get a formula to display the lookup thats in row 7 as well as column d??
ive tried to put in a example table below
thanks
a b c d e f g h
1
2
3
4
5
6
7 ?
8
9
10
Bookmarks