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

=vlookup(AL29,$AI$11:$AJ$200,2,False)

--
Regards,
Tom Ogilvy

"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/

Im not sure where you pulled all those numbers from?! Can you give me a
explination of every new number

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

I pulled them from your posting:

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

My assumptions:

so the name to look up is in AL29

the columns to look in are AI containing the list of names and AJ the pay
rate or whatever you are trying to return

the 2 says to return the value in the second column of the lookup range (AJ)
for the matching row.

the false means to find an exact match.

=vlookup(AL29,$AI$11:$AJ$200,2,False)

I assumed the names start in AI11 and run to AI200 (adjust for your actual
ranges).

All this is spelled out in help.

--
Regards,
Tom Ogilvy



"DangerMouse114 " wrote in
message ...
Im not sure where you pulled all those numbers from?! Can you give me an
explination of every new number?


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

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/