Hi ya'll I am sorry I keep askin questions, but I have just one more.

Say I have 2 tabs and sheet1 has a list of 150 differnt numbers in
column A. with other information in columns b thru dg. I would like to
know if there is away to go type a number on sheet2 and it
automatically goes to sheet1 matches it with a number in column A, but
in a different column on sheet2 it puts the info from a certain cell
on the match of sheet1.