B Excel formulas

Hi, team.

I have 4 formula segregated columns in sheet 1,

Thanks in advance

Accepted answers

No worries @Inactive User, make sure to ask if you have any further issues 😄 If that solution works make sure to give it a green tick !

Hey @Inactive User,

Would you be able to provide enough information for the Excel formulas to work?

@IraWatt Sure I will be right back

In the mean while can you share the above workflow@IraWatt

@Inactive User sure no worries. I was planning to use the join tool for the V lookups and use a union tool to combine all the data at the end.

@IraWatt Here is the file, please ignore n/A alues. Thank you in adance

@IraWatt Please help

@Inactive User One way of dong this

Hey @Inactive User,

I have updated my workflow here:

Had a quick look through and it looks the same as your Excel file.

Any questions or issues please ask
HTH!
Ira

@IraWatt Thanks alot

No worries @Inactive User, make sure to ask if you have any further issues 😄 If that solution works make sure to give it a green tick !

Done

Thanks @Inactive User 😄