skip the row if there is a error or 0.

[SS149]

Good day,

I'm new to this so please bare with me. I would like to have specific information from a row transferred from sheet3 to sheet4 when a name is selected on sheet3 via the drop down list in column A. If the cell is blank in column A I would like it to do nothing on sheet4. The problem I am running into is that on sheet4 it gives me error or 0 when a cell is blank in column A on sheet3. In a perfect world I would like to skip the row if there is a error or 0.

Hope I was clear enough thanks.

Sheet3 is transactions
Sheet4 is account payable


sheet3
The information I would like transferred is Name (column A) , Date (Column B), Expense (Column D) and Description (column G)

to

Sheet 4
Date (column A), Name (column B), Description (column C) and Total (column J)

here are the formulas I have so far on sheet4
date
=VLOOKUP(B2;$Sheet3.A11:H28;2;FALSE())

name
=$Sheet3.A11

total
=VLOOKUP(B2;$Sheet3.A11:H28;4;FALSE())

ideally i would like it to come out like the last image.

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[SS149]

Alright here you go.

[SS149]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Alright here you go.

[:) Sixthsense :)]

In A2 Cell of sheet4 - Array Formula - Requires CTRL+SHIFT+ENTER


=IFERROR(INDEX(sheet3!A$2:A$41,SMALL(IF(sheet3!$A$2:$A$41<>"",ROW(sheet3!$A$2:$A$41)-ROW(sheet3!$A$2)+1),ROWS($1:1))),"")


Drag it down and right...

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

Used Iferror() which will work with Excel 2007+ versions only

[SS149]

Thanks for the reply. I've opened the file you sent and instead of it adding the Name (column A) , Date (Column B), Expense (Column D) and Description (column G) from sheet3 it added the whole row.

[SS149]

In A2 Cell of sheet4 - Array Formula - Requires CTRL+SHIFT+ENTER


=IFERROR(INDEX(sheet3!A$2:A$41,SMALL(IF(sheet3!$A$2:$A$41<>"",ROW(sheet3!$A$2:$A$41)-ROW(sheet3!$A$2)+1),ROWS($1:1))),"")


Drag it down and right...

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

Used Iferror() which will work with Excel 2007+ versions only

Thanks for the reply. I've opened the file you sent and instead of it adding the Name (column A) , Date (Column B), Expense (Column D) and Description (column G) from sheet3 it added the whole row.

[:) Sixthsense :)]

Thanks for the reply. I've opened the file you sent and instead of it adding the Name (column A) , Date (Column B), Expense (Column D) and Description (column G) from sheet3 it added the whole row.

Unable to understand what you are trying to convey...