B
Brian
Thank You
Both worked perfect. But just so I can learn, what does
the number 2 in the vlookup function you both gave me
mean.
=VLOOKUP(C1,$A$1:$B$20,2,false)
=Vlookup(A1, J1:K50, 2, false)
and why did one formula have $ signs within the cell
location and not in the other
sorry for the questions, but you help is very appreciated
thanks,
Brian
Both worked perfect. But just so I can learn, what does
the number 2 in the vlookup function you both gave me
mean.
=VLOOKUP(C1,$A$1:$B$20,2,false)
=Vlookup(A1, J1:K50, 2, false)
and why did one formula have $ signs within the cell
location and not in the other
sorry for the questions, but you help is very appreciated
thanks,
Brian