nth value

I have this formula, I am running into an issue when I want the nth value, but it matches the nth value for another column, then does a match to get what value in this column. Visual is below. Column B matches the index of Column C to return a value based on the value. I want it to show what the...

I came up with this formula INDEX('TABLE INPUT'!$B$6:$AAZ$309,MATCH($A7,INDEX('TABLE INPUT'!$C$6:$AAZ$309,0,MATCH($E7,'TABLE INPUT'!$A$3:$AAZ$3,0)-7),0),MATCH($E7,'TABLE INPUT'!$H$3:$AAZ$3,0)) I know i need to use small or large but I tried and get a #value error message <tbody> -> 47A x...

Hello. In columns A and B (A2:B600) I have a lists of customer names and their buying prices in columns D and E (D2:E600). When customer name is in column A his buying price is in column D (same row of course) and when customer is in column B his bying price is in column E. I'm trying to...

Hi, I couldn't find this answered exactly on the forum. Sorry if it has. I am looking to return the column number of the nth occurrence in a row. So in the example in the table below, I am looking to return the column number in row 1 of the 2nd (B4) occurrence of the word 'dog' (B3). In this...

Hello everyone, I've got a question about the large function in vba. I've searched the internet but couldn't find an answer so I hope you can help. In a sheet there's a range (column c) that contains numbers. The search range is fixed, the Numbers not. I want to search for the highest and...