Ok Im having trouble with this one I need a formula that can compare on
cell to a list of cells, when and if they match then I need the cell t
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 pa
to be shown next to a cell that will display any random name from th
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 formul
would work. It obviously did not.

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

Thank

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