Hello everyone

I have the following two queries:

1. I want to average values that meet a specific condition i.e. I know how
to use an IF statement but I don't know how to average those values that meet
the IF statement.

2. I want to lookup along a single row with no other data and take the value
to the right of the word I am searching. I know hlookup doesn't work because
it will only associate with fixed parameters. In my case I want to always
take the cell to the right of another cell in a single row and this cell
might be changing in the spreadsheet.

Thanks in advance