B Excel formulas

[Inactive User]

Hi, team. 

I have 4 formula segregated columns in sheet 1, 

Thanks in advance

[IraWatt]

Hey @Inactive User,

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

[Inactive User]

@IraWatt Sure I will be right back

[Inactive User]

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

[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.

[Inactive User]

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

[Inactive User]

@IraWatt Please help

[binuacs]

@Inactive User One way of dong this

[IraWatt]

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

[Inactive User]

@IraWatt Thanks alot