Forum Discussion
Look at another sheet if cell is blank
I am working on creating an excel file with multiple sheets containing a large amount of data. My goal is to have 1 Row containing an item and the row beside it having a formula for returning th...
=IF(VLOOKUP(A2;sheet1!$A$2:$B$25;2;FALSE)<>"";VLOOKUP(A2;sheet1!$A$2:$B$25;2;FALSE);IF(VLOOKUP(A2;sheet2!$A$2:$B$25;2;FALSE)<>"";VLOOKUP(A2;sheet2!$A$2:$B$25;2;FALSE);IF(VLOOKUP(A2;sheet3!$A$2:$B$25;2;FALSE)<>"";VLOOKUP(A2;sheet3!$A$2:$B$25;2;FALSE);"Unavailable")))
In my example i have data in range A2:B25 in all 3 seperate sheets.
In the main sheet i enter above formula in B2 and copy formula down.