Ok heres a tough one....

D

DangerMouse114

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
 
B

Bob Phillips

IF(NOT(ISERROR(MATCH(AL29,AI11:AI100,0))),INDEX(AJ11: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)
 
D

DangerMouse114

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

Tom Ogilvy

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.
 
Top