[Solved] Finding Formula to match two points.

[amyhart420]

I can't figure out the formula I need for the life of me. I have a table with 2 headers. Top Header is a list of classes, the left header is the list of Skills. I need to match up the two and return the result of that crossmatched cell.

The two formulas I am using to select which row and which column headers I need to match are as follows.

Vlookup('Fill In'.B3;'Class Info'.A1:BC423;55;0)

LOOKUP(Calculations.H6;Skills.A1:R86;Skills.A1:A86)

1st is the Top header info and 2nd is the left header info.

Any help is appreciated. Thanks

[JohnSUN-Pensioner]

It can be something like this

Code: Select all

=OFFSET(<start_of_table>;N(MATCH(<row_header>;<first_column_of_table>;0));N(MATCH(<column_header>;<first_row_of_table>;0)))

I would gladly rewrite this formula for you in your terms, but I could not understand the relationship of'Fill In'.B3 - 'Class Info'.A1:BC423 -
Calculations.H6 - Skills.A1:R86

Update Oh, I see 3.3.1 in your signature. I don't remember if in this version the function N()

[amyhart420]

'Fill In'.B3 - 'Class Info'.A1:BC423 -
Calculations.H6 - Skills.A1:R86

Are referencing to cells and ranges on other sheets, ie, 'Fill In' is 'Sheet 1' on a new Document.

N() is an available function but it did not work when I plugged in it as you have it written, perhaps due to the multiple sheet issue.

[JohnSUN-Pensioner]

Probably my bad English is guilty - I still don't understand which cell contains the required row, which cell contains the desired column, and what range contains the table for searching.
Perhaps it would be easier to see a sample of your spreadsheet? I understand Calc's formulas better.
Or look how it's done in my sample

[amyhart420]

Okay I see how you have it set up now. That isn't how I was trying to set it up but that can actually work. I'm gonna try to get it set up using my different sheets and I will let you know if it works out. Thanks for the help.

[amyhart420]

I got it plugged in and it works perfectly. Thank-you so much.