Hi There!
I am hoping you can help, I am looking for a way to make my formula ignore blank results and only show results that contain text.
My Creditors report is split by what the supplier does for us, and there are 4 categories
1. Construction
2. Supplier
3. Consultant
4. Land
I am trying to generate in column E, the supplier name if they are a ‘construction’ supplier, dictated by column A in the tab names ‘Supplier Listing’.
This works well for the ‘Construction’ creditors in rows 4 – 24 of the creditors report, but when I get down to ‘Suppliers’ (rows 30 – 132) I am left with the blank cells in rows 40 - 55 as my formula asks it to return blank if not true.
=IF('Supplier Listing'!A2=Creditors!B4,'Supplier Listing'!B2, "")
Is there a way I can eliminate the blank cells? Can I make the search skip to the text I am looking for and start the lookup once it has automatically found the first cell containing ‘construction’ or ‘supplier’?
The list of suppliers on the supplier listing tab will change each week, so I want this lookup to be automatic – not to use index/match to tell it which row to start from as it will not be the same each week as new suppliers are added.
I really appreciate your help! =)
(Please advise if i can send my file for you to look at - I cant seem to put any pics on here)
I am hoping you can help, I am looking for a way to make my formula ignore blank results and only show results that contain text.
My Creditors report is split by what the supplier does for us, and there are 4 categories
1. Construction
2. Supplier
3. Consultant
4. Land
I am trying to generate in column E, the supplier name if they are a ‘construction’ supplier, dictated by column A in the tab names ‘Supplier Listing’.
This works well for the ‘Construction’ creditors in rows 4 – 24 of the creditors report, but when I get down to ‘Suppliers’ (rows 30 – 132) I am left with the blank cells in rows 40 - 55 as my formula asks it to return blank if not true.
=IF('Supplier Listing'!A2=Creditors!B4,'Supplier Listing'!B2, "")
Is there a way I can eliminate the blank cells? Can I make the search skip to the text I am looking for and start the lookup once it has automatically found the first cell containing ‘construction’ or ‘supplier’?
The list of suppliers on the supplier listing tab will change each week, so I want this lookup to be automatic – not to use index/match to tell it which row to start from as it will not be the same each week as new suppliers are added.
I really appreciate your help! =)
(Please advise if i can send my file for you to look at - I cant seem to put any pics on here)