How to Search Table for Intersecting X and Y Axis Values

[JNEWBURY2280]

I have searched the help extensively but can't seem to figure out how to search a table for intersecting X and Y axis values.

I know by using the LOOKUP() formula you can search for a particular value in a range of cells but that only allows me to search in one axis at a time.

Maybe its a combination of formulas that I need like INDEX() and others?

[jeffreybrown]

Hi JNEWBURY2280 & Welcome to the Forum,

Maybe this will help...

[TMS]

You need to use the INDEX/MATCH(row)/MATCH(column) construct.


Regards, TMS

[Tony Valko]

You can use a VLOOKUP function or a combination of INDEX/MATCH/MATCH.

I think VLOOKUP is easier to use.

Need more detail before I can suggest anything more specific.

[FDibbins]

Almost there take a look at the index/match/match combo

[JNEWBURY2280]

It was the =INDEX(select all table values,MATCH(Y-Axis Value,All Values in the Y-Axis,0),MATCH(X-Axis Value,All Values in the X-Axis,0))

The MATCH just results the location of both the Y and X Axis.

The INDEX uses those two values and hunts for the answer!

THANKS FOR THE HELP!!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.