Formula to return info from one workbook to another based off a specific column

tuttlemom

New Member
Joined
Jan 28, 2025
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have a workbook with invoice data. There is a column called amount outstanding. When that column says $0.00, I want specific data from that line to fill in (spill over) to my 2nd workbook.
Example - Workbook 1 called Kyle Sales and Bid Log
On tab Sales Log 2025, when column AO says $0.00, I want that line to then feed into 2nd spreadsheet - called Marlyn 2025 Summary. There are only certain items I want brought over from the Sales and bid Log. I would like for the cells to remain empty until the column in workbook 1 is $0.00.
I thought I had the formula correct but it returned the word FALSE in every cell or it would return data, even if column AO didn't say $0.00.

Pictures are below I'd appreciate any help I can get!
 

Attachments

  • Kyle Screenshot.jpg
    Kyle Screenshot.jpg
    167.2 KB · Views: 7
  • Marlyn Screenshot.jpg
    Marlyn Screenshot.jpg
    44.2 KB · Views: 7

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,226,114
Messages
6,189,052
Members
453,522
Latest member
Seeker2025

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top