Hi there, first post.

I have a workbook with 3 sheets, and i would like to be able to enter a
certain value into a cell on the first page and have excel return a row
of data from the second page to the third page.

On the first sheet, I want to enter a code like "AB123". The
corresponding data is in on the second sheet in column A, in a format
like "VBA__2Y123". In either format, the final numbers are always 3
digits long and are identical. On the first sheet, the "AB" portion is
always a two-letter code. On the second sheet, the "VBA__2Y" portion is
always 7 characters long.

Can I do something like use a "Let" statement?

For example:
Let Left(format1,2)= "AB" = Left(format2,7) = "VBA__2Y"

Am I totally out in left field on this?

Any suggestions that you might share would be greatly appreciated. As
you can tell, I am really new to VBA...

Thanks!