I am trying to develop a formula to look at (example): cell a9 and cell e9 on
the first tab, then find matching data on the 2nd tab (e.g., 1st tab cell a9
looks at 2nd tab 1st column and 1st tab cell e9 looks at 2nd tab 5th column =
if these both find a match, then return the data on 2nd tab 6th column.

Here is my formula:

=IF(VLOOKUP(A9,'Defect Type'!A:H,1,FALSE),IF(VLOOKUP(E9,'Defect
Type'!A:H,5,FALSE),'Defect Type'!F2,"FALSE"))

I know the first row has matching data and should return data, but so far
all I'm getting is an '#N/A'. Any thoughts?

Thanks!