I have a list of values on sheet 2 as follows; A2=X, A3=Y, A4=Z. B2=1, B3=4, B4=7. C2=2, C3=5, C4=8. D2=3, D3=6, D4=9. Can a formula be written so that if the letter X,Y or Z is entered in any random cell of column A in sheet 1that columns B,C and D will automaticly display the corrisponding information? Example; I would type Y in any cell in column A in sheet 1 and column B,C and D would display 4,5 and 6.