If vlookup value returned = 0 do a vlookup on an alternate column and return corresponding

Hi,
I have a standard vlookup formula: =VLOOKUP($A6,'Base Model'!$A$3:$I$5000,8,FALSE) which returns the corresponding value from column 8 of excel sheet named "Base Model". I want to amend the formula to do a vlookup on column 9 and return the corresponding value If the value returned from the original vlookup is "0". Hope someone can help.

Many thanks,
AP

Hi, maybe

Please Login or Register  to view this content.