Help needed in cell routing

[daysamuel]

Hi all,

I need some assistance as I cannot figure out which formula or if this is even possible (I hope it is) to do across a number of sheets in a workbook.

To ease explanation I will refer to two sheets, 'Summary' and 'Figures'

Basically the idea is, I want to have a Summary sheet, which has a cell showing a figure from another sheet. However, the figure I want it to display can be one of two cells on the Figures sheet... Bare with me on this.

The Figures sheet is set out that it has a permanent figure in cell A1 (for this purpose it is a budget) and in cell A2 it has a figure which may or may not exist (for this purpose it is actual spend). I want the cell on the Summary sheet to show the figure in A2 on the Figures sheet ONLY if data has been entered (In this case if money has been spent or not). If no data is inputted into A2 then I want the cell on the Summary sheet to show the Data from cell A1 on the Figures sheet.

Is there a formula that can do this?

I appreciate any help!

Thanks

[JohnTopley]

Attach a sample workbook not image)

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[daysamuel]

Please find the attachment, hopefully this gives more of an explanation

[daysamuel]

Attach a sample workbook not image)

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Find attached, I have revised the first upload with desired result in red and italics

[JohnTopley]

Try

=IF(LEN(VLOOKUP(A2,Figures!$A$2:$C$4,3,0))=0,VLOOKUP(A2,Figures!$A$2:$C$4,2,0),VLOOKUP(A2,Figures!$A$2:$C$4,3,0))

[daysamuel]

Try

=IF(LEN(VLOOKUP(A2,Figures!$A$2:$C$4,3,0))=0,VLOOKUP(A2,Figures!$A$2:$C$4,2,0),VLOOKUP(A2,Figures!$A$2:$C$4,3,0))

Perfect, thank you very much for your help!

[daysamuel]

Try

=IF(LEN(VLOOKUP(A2,Figures!$A$2:$C$4,3,0))=0,VLOOKUP(A2,Figures!$A$2:$C$4,2,0),VLOOKUP(A2,Figures!$A$2:$C$4,3,0))

UPDATE: I have amended this formula to use on my spreadsheet however it doesn't seem to be working correctly. Due to sensitive information I cannot upload the spreadsheet.

The issue I'm having is the formula picks up the data in the 'Figures' spreadsheet with no issue however it doesn't change to the manually inputted data when it is entered on the 'Figures' sheet.

Any ideas?

Thanks

[JohnTopley]

however it doesn't change to the manually inputted data when it is entered on the 'Figures' sheet.

I don't understand the above.

Without a file simulating the problem it is not possible to say what is wrong