% Formula help

B

Boenerge

Hi,
What formula would I use if I wanted a cell to report a percentage.
The percentage I would require is for the cell to search a column e.g.
"B6:B172", look for a particular term e.g. "G" and then look across the row
to a particular cell e.g. "G6" to see if anything has been inputted.

Thanks in advance

Jason
 
N

NBVC

Is the percentage what is in column G?

You can use Vlookup maybe.

e.g

=Vlookup("G",$B$6:$G$172,6,FALSE)

you can replace "G" with a cell reference containing the "G".

this looks for a G in column B and reports what is in the 6th column o
the range B6:G172... i.e. column G

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com
 
Top