IF function

[beachy302]

I have 25 information cells, in a separate cell it will tell me which box to get my information from. I want a formula in another box to show the information from that cell. If cell A says 10, I want cell B to show the information in cell 10; if it says 25 in cell A then I want box B to show what's in cell 25... etc. I've tried using the IF function but can't quite get it correct.Thanks

 

[Joe4]

=IF(M5=2,K45) works for the one result but I need it to work with the other possible results... =IF(M5=2,K45) and =IF(M5=3,K44) and =IF(M5=4,K43) and so on.

This is very confusing. This appears to be quite a bit different than the first few posts. If there is any sort of predictable "pattern", then we can probably do what you want. I am just trying to understand what this pattern is.

Based on this most recent post, it looks like it is going backwards, i.e. as the value of M5 increases, the row from column K decreases, in a one-to-one relationship. If that is the case, then you should be able to use this variation:

=INDIRECT("K" & (47-M5))

Does that work?

Hopefully, you are beginning to see the pattern of these indirect formulas. Essentially, we are just building the range reference we want to pull.
The issue is, if we just do it like this:

="K" & (47-M5)

if M5 is 2, that formula will return the literal value "K45", not the value from that cell.

What surrounding that calculation by the INDIRECT function does is tell Excel that I want to return the value from the cell reference that this calculation returns.
Make sense?

 

[beachy302]

Thanks but no that doesn't work. I think I'm confusing the situation more with how complicated the spreadsheet is already so I've started a new sheet to just figure this out.
In column A I have numbers 1 - 26 in each row (A1 is 1, A26 is 26)
In column B I have letters A - Z in each row (B1 is A, B26 is Z)
In cell C1 I will input the number that I want to reference (1 - 26)
In cell C2 I want the formula to tell me the corresponding letter to the number

How does that sound?

Thanks again for your patience

 

[Joe4]

In that case, a VLOOKUP may be more appropriate here. The formula would look like:

=VLOOKUP(C1,A1:B26,2,0)

See here for an explanation on how VLOOKUP works: https://www.excel-easy.com/examples/vlookup.html

 

[beachy302]

That's it, I was able to then change the formula to work in the more complicated sheet. Thanks so much for your help and patience!

 

[Joe4]

You are welcome.
Glad we got it all sorted out.