Needing an IF looukup formula that has two IF variables...

[greenfox74]

Hi again all. It's been a while, but back and needing a little help if possible from one or more of you gracious excel experts.

What I'm trying to do is I have two different variables. On the sheet attached is where I'm at. In cell C8 is one variable. C10 is the other. A3 thru F3 is where I need the data to go to. A2 thru F2 I have figured out already. I'm needing A3 thru F3 only. I need for A3 thru F3 to determine what is in C8 and C10 and look to the right to find that combination, take the data that is there and fill in A3 thru F3. Like in the file uploaded. I have 3 in C8 and 8 in C10. With these two digits being there, it will go over and find that number match up. I have it highlighted in green and is in AM27 thru AR27. So A3 will take the data from AM27, B3 will take AN27 and so on until A3 thru F3 is filled.

If C8 was a 2 and C10 was a 9, then A3 thru F3 would take cells AC30 thu AH30. So on and so forth. This has all combinations of 0-0 thru 9-9 so it may be tricky. (For me anyway, I'm sure it's something simple for you guys/gals). I can rearrange I thru CZ to an easier way if need be. Like put all that data in I thru N if need be. That's not a problem at all. I'm really hoping I've worded this so that what I'm needing will make sense. I'm kind of tired right now, so it may not. I can try to clarify whatever is needed more if I need to, but the upload will probably have to be looked at to see what I'm needing.

I know there is some here that can help me with this. Y'all haven't let me down yet. Thank you to each of you for all your help!!!

[greenfox74]

After looking and looking at what I'm attempting, I think I'm just going to rearrange my selections another way and use the index and match functions. I think will be the best way to go about this. It's going to take some time, and may be more of a caveman way, but I think it will work. A great big thank you to all who even looked at this for me. I know there are MANY on here that are like myself and see something that has a challenge to it and just can't stand to not figure it out. Not that this one is some big challenge. That's what makes this place so great. No need in anyone wasting anymore time on this one, unless it's just something for your interest. If anyone is interested as to how I end up doing it, I'll be glad to share what I do with it. When I finish straightening it out that is.

As always, thank you to all of you for your time!!!