Using the INDEX and MATCH Formula to pull costs.

Hello there.

I'm new to the forum. Currently at work and trying to work on an excel sheet we use.
Trying to make like a little easier and quicker, so we aren't typing costs into a cell manually.

To put you in the picture. We have 3 columns, Delivery Numbers, Invoice Numbers and Gross.
I have a fully working function to pull the Gross amount when searching through the Delivery Numbers.

Please Login or Register  to view this content.

Now, sometimes we don't use a delivery number and only have an invoice number.
Is it possible to check the invoice column 'E:E' and check is 'B:B' is a blank cell. If it is then pull through the gross?

Not sure if you need more information. If you do please let me know.

Maybe more better if you give us some detail information in sample workbook

Regards
Azumi