Hello there,
I am looking to create an Excel form that is used to register customers that come to my workshop. It's annoying for repeating customers to have to share their details every time they come in.
This is why I have a VLOOKUP on all input cells (Address, email etc.) comparing the "name" cell with sheet the second sheet that stores the customer information.
However, I would also like to be able to search this second sheet using the customers plate number. Is there a way to perform two VLOOKUPS in one cell and choose one of the two found cells based on their content?
Ergo: Name cell is empty, plate number cell is populated > Address, email etc. get filled based on plate info
And vice versa.
Bookmarks