Countif function help
There is no missing parenthesis in that formula.
Also, the second VLOOKUP's lookup range must be at least E:G, not E:F.
OTOH, if you're trying to match the value in cell E2, don't put "e2" in
quotes. If you're trying to find the text value "e2", don't use the cell
reference e2 in the VLOOKUP() statement.
XL is persnickety. It attempts to execute what you type, not what you
intend.
In article ,
Haz wrote:
=IF(ISNA(MATCH("e2",Sheet1!E:E,FALSE)), "", VLOOKUP(e2,
Sheet1!E:G,2,FALSE) + VLOOKUP("e2",Sheet1!E:f,3,FALSE))
|