Vlookup to populate from sheet but if column is empty then use a different one?

[kellyfirth]

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!

[Richard Buttrey]

Hi,

Would you upload the workbook and manually add some results so that we can better understand exactly what you want.

[Vikas_Gautam]

Try this...(Untested Though)

Please Login or Register  to view this content.

Edit:- Lookup formula was wrong so I am giving Index Match formula.

[kellyfirth]

I believe this has worked, thank you!