Returning values with multiple conditions

sslll

New Member
Joined
Jan 29, 2024
Messages
2
Office Version
  1. 365
Platform
  1. Web
Hi Guys,

I have difficulty of returning the values according to the conditions. Appreciate it if you could look into it and share your knowledges and expertise on this issue.

some data in column A ( FY 22 and FY23 client code) has associated billing number(s) in Column D (Billing Numbers). Using Column B (FY23 Client code), it is to identify the same data in Column A and to return all associated data in Column D (Biling Number) and in Column F(document billed gross Amt) in respective column with comma (if there are multiple values return). Upon comparison of column B and A and if only one billing number is found, first column returns to corresponding billing number and subsequent columns returns to "No Further bills" If data in column B is not matched with the one in column A, it is to return "not found".

Raw Data​
End result​
FY22 and FY23 Client codeFY23 Client codeAR CodeBilling NumberDate BilledDocument Billed Gross AmtFY23 client codeBilling NumberDocument Billed Gross Amt
A-66063406
A-66335647​
12151918AS01A00004267525 Jul 202217,676.40A-66335647AS01A000055978, AS01A000055982
17,841.60,1,080.00​
A-66335647
A-67401729​
12151918AS01A00005597820 Jun 202317,841.60
Not found​
Not found​
A-66335647
A-67401729​
12151918AS01A00005598220 Jun 20231,080.00
Not found​
Not found​
A-66063406
A-66335647​
12174743AS01A00003805725 Apr 202232,742.00A-66335647AS01A00005597950,667.12
A-66063406
A-66335647​
12174743AS01A00004267225 Jul 202242,778.60
No Further Bills​
A-66335647
A-67401729​
12174743AS01A00005597920 Jun 202350,667.12
Not found​
A-66458454
A-67255819​
12760057AS01A00004683514 Nov 202210,914.00
Not found​
Not found​
A-66458454
A-67255819​
12760057AS01A00005026103 Mar 202311,016.00
Not found​
Not found​
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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