Easy I know, but here's the twist there's no reference number to use a find, "vlookup, hlookup, index" I need to write a formula that will search down the x line of a table then down the y line and come to a result here's an example
(Y)
3-------(X1)
2 +
1 +
0 1 2 3 (X)
So I nee a formula that could go down the x line and stop at 2 then go down the y line and stop at 3 then go over and up to find the value in this case (X1)
I've tried to run an index but it won't reference two different values and I can't create an if statement that would work... Help!!!
Bookmarks