IF(NOT(ISERROR(MATCH(AL29,AI11:AI100,0))),INDEX(AJ 11:AJ100,MATCH(AL29,AI11:A
I100,0)),"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"DangerMouse114 " wrote in
message ...
Ok Im having trouble with this one I need a formula that can compare one
cell to a list of cells, when and if they match then I need the cell to
equal the cell to the right of the one that matches.

I have one column of names. Next to it is an hourly pay.

Elsewhere on the form i have a column in which i need the correct pay
to be shown next to a cell that will display any random name from the
list of the first name column.

I tried and IF formula but it did not seem to work.

Heres what i tried...

=IF(AL29=AI11,AJ11,"if(AL29=AI12, AJ12, """)

in the "if does not equal to" area i thought adding another IF formula
would work. It obviously did not.

If this would have worked it would have taken me FOREVER to set up so
if you know an easier way please share it!

Thanks


---
Message posted from http://www.ExcelForum.com/