__1st PROBLEM:__How to COUNT/SUM of where cells that DON'T contain "#N/A" in column G & cells that DO contain "#N/A" in column F.

This is what I have and I'm trying to have the count on G11

F G

5) #N/A Archived

6) #N/A Archived

7) #N/A Archived

8) #N/A Archived

9) Green #N/A

10) #N/A #N/A

11) =F(x)

Q: IS THERE A WAY TO COMBINE THESE EQUATIONS INTO ONE?

Right now I have one column for =COUNTIF(G5:G10,"<>##N/A")

&

Another column for =COUNTIF(F5:F10,"=#N/A")

This is what I have tried

=SUM(IF(G5:G10<>"#N/A"))+SUM(IF(F5:F10="#N/A"))

=SUM(IF(G5:G10<>"#N/A",IF(F5:F10="#N/A")))

*I even tried the ctrl+shift+enter

__2nd PROBLEM:__Q: after googling it seems like you can't look up have more than one cell w/ "vlookup" function, is that true?

Objective: In sheet 1, there are columns A-D with data

In Sheet 2 there are columns A-K with data, Column L is the active column w/ the f(x)

In Sheet2 L2, I want it to search Sheet2 E2. within the array of Sheet1! B:C, and then output Sheet1! C. But if they don't find anything, then Sheet2 L2 will search in Sheet2 K2, within the array of Sheet1! B:C, and then output Sheet1!C

Index/Match won't work because i'm not trying to search something w/ multiple conditions.

i'm trying to combine a "Vlookup" function with an "OR" function"

In other words, my brain is thinking:

SHEET2! L2=VLOOKUP(OR(IF(SHEET2!E2,'SHEET1'!B:C,3,FALSE),IF(SHEET2!K2,'SHEET1'!B:C,3,FALSE)))

Anyone who can help me out w/ any of these scenarios, MUCH APPRECIATION!!