My query is really in the topic title.
I am in the midst of running my own exercises on various workbook uses and am currently building some basic invoices. I've come across what should be a very simple problem to solve but just can't get my head around it:
This workbook has several w/sheets, i.e, Invoice, Products and Customer List. Using VLOOKUP, as per the lessons in Expert Skills I have easily referenced my products, products descriptions and prices in the invoice body.
When it comes to my customer address field in the invoice body, I have also successfully referenced my customer list w/sheet to that, using VLOOKUP, except for when it comes to a blank cell in the customer list w/sheet table. My Customer List table has 2 fields (i.e. Address 1 and Address 2); Address 1 is always filled, but Address 2 is sometimes not (some addresses have several lines hence using 2 fields for the address).
Following Mike's lessons on this I understand the concept of using IFERROR with VLOOKUP, to return a value other an error, but what I would like to achieve is where the cell is blank (i.e. Address 1 field), move on to the next column (Address 2), and take the value from that instead.
Is this achievable using the VLOOKUP function or combined with another function(s)?
Hopefully the above is clear, but I can attach the w/book if required.