I need a formula (presumably Vlookup) which will populate with the contents of A1 in sheet2 (I want to be able to drag this down for lots of rows though). However, if A1 is empty or says: #N/A N/A, then it will populate from B1. If B1 is empty or says: #N/A N/A then it will populate from C1. If none are available then it will simply say: No Price.
Sorry, this probably has quite a simple solution but I'm only used to vlookups for one column, not checking the contents of them and then populating from another.
Thanks for any help!
Bookmarks