Nested Index/Match/Match problems

I am trying to write a formula where if there is no information in the first column, then look to the next column to see if there is anything there, if something is found then execute the formula. I have managed to get it working for two columns, however not sure if that is the limitations with the formula I'm using. I'm using Index/Match/Match to lookup from the table below. So if there is nothing in L, then move on to N etc. I started in U and have managed to get U and V working, however can't get any more.

Capture.PNG

It's quite a complex spreadsheet, however what it's saying is that if there is a yes (or y) in columns I or J, then start looking at column U and match the amount . If that combination is found in the table on the next sheet, bring back the amount and multiply it by figures I have in columns E & X. If no data in column U then move on to column V.

This is the lookup table in Sheet 2:
Capture2.PNG

...and the formula I have so far:

=IFERROR(IF(OR(I11="y",J11="y"),INDEX('Sheet2'!C42:N56,MATCH(U11,'Sheet2'!B42:B56,0),MATCH('Sheet1'!U2,'Sheet2'!C41:N41,0))*E11*X11,IF(AND(I11="n",J11="n"),INDEX('Sheet2'!C23:N37,MATCH(U11,'Sheet2'!B23:B37,0),MATCH('Sheet1'!U2,'Sheet2'!C22:N22,0))*E11*X11)),IF(OR(I11="y",J11="y"),INDEX('Sheet2'!C42:N56,MATCH(V11,'Sheet2'!B42:B56,0),MATCH('Sheet1'!V2,'Sheet2'!C41:N41,0))*E11*X11,IF(AND(I11="n",J11="n"),INDEX('Sheet2'!C23:N37,MATCH(V11,'Sheet2'!B23:B37,0),MATCH('Sheet1'!V2,'Sheet2'!C22:N22,0))*E11*X11)))

Apologies if this does not make any sense whatsoever, however any help would be appreciated.

As this is your first post, welcome to the forum (although you seemed to have joined last year).

It would help if you attached a sample Excel workbook, rather than pictures of one (which can't be edited).

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Do not try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

P.S. Being several hours ahead of you, I'll be going to bed soon, so someone else might chip in while I'm asleep.

I can't see the attachment - did you remember to click on Upload?

Pete

Sorry I had to edit the file - try now.

Yes, I can download it now, but at 1:40 am, it really is time for me to go to bed.

Pete

Thanks FlameRetired, I'll give that a go. I do know about relative/absolute cell referencing - just trying to get the formula right to start with.

Everything I've tried so far doesn't work unfortunately.

Apologies, I've tried inserting the isnumber formula into my existing formula and only get a #NA or #Value in return. I'm obviously not adding it in correctly, as everything I try fails.

You're both stars - both work perfectly, thank you