Need to grab an intersection of two numbers. Example attached. Should be pretty simple.
Need to grab an intersection of two numbers. Example attached. Should be pretty simple.
Formula in I2
Formula:Please Login or Register to view this content.
One way...
=VLOOKUP(H2,A1:D12,MATCH(G2,A1:D1,0),0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
This formula gives the value 19.
Thanks! This Worked1
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks