Apr 30 2019 04:02 PM
Hi,
I am new to the community and somewhat new to the formula side of excel. Working on an excel sheet created by someone else. I would like help breaking down this formula. What do the individual parts do? This formula brings in data from another workbook, not sure how that is set up.
=IF(OR(HLOOKUP($B$1,Sheet1,$AD6,FALSE)="n/a",HLOOKUP($B$1,Sheet1,$AD6,FALSE)=0),"",HLOOKUP($B$1,Sheet1,$AD6,FALSE))
All input greatly welcomed,
Thank you
Apr 30 2019 04:50 PM
Hi @Colt45
=IF(
OR(
HLOOKUP($B$1,Sheet1,$AD6,FALSE)="n/a",
HLOOKUP($B$1,Sheet1,$AD6,FALSE)=0
),"",
HLOOKUP($B$1,Sheet1,$AD6,FALSE)
)
So the HLOOKUP part is trying to find a matching value to B1 across the columns of Sheet1
it will then bring back the value from the row number that is in AD6
The IF part is checking if that returned value is "n/a" or 0 in which case it returns "" (empty cell)
Apr 30 2019 04:54 PM
SolutionAlso Sheet1 is a defined Name
If you go to the Formulas menu and click Defined Name you'll see where that Sheet1 is referring to
May 07 2019 10:56 AM
Apr 30 2019 04:54 PM
SolutionAlso Sheet1 is a defined Name
If you go to the Formulas menu and click Defined Name you'll see where that Sheet1 is referring to