Linked to looking up

[Cmorgan]

Evening,

If anyone could help I would be very greatly, otherwise this is going to take forever

I'm using this formula:

=AVERAGEIF('Input Sheet'!G:G,"AARD",'Input Sheet'!H:H)

It works, but I'm looking at having to change the "AARD" about 112 times to different things.

What I would like to do is change it, so rather than putting whatever it is looking for within the "", I want it to check a cell, for example C4.

Thanks for any help.

[JBeaucaire]

So just put that in the formula, surely you tried it?

=AVERAGEIF('Input Sheet'!G:G, C4, 'Input Sheet'!H:H)

[Cmorgan]

Thanks, for this. I was putting , and/or " in the wrong place - total newbie to excel.