Formula/Macro to reference from other Worksheet

I'm pretty sure this is the right section, if not feel free to yell at me and i'll post in the appropriate one.

Maybe it's not as complicated as i'm thinking, but i'm trying to figure out a formula (or macro) that will let me basically fill in a blank from a (nearly) irrelivant second worksheet. The only similarity the two will have is a PO number, or in my picture diagram, it's a letter. The worksheet that i'm trying to fill in the blank from has maybe 1500 entries, the worksheet i am referencing to has roughly 11,000, so sorting it would make no difference and the columns would be very inconsistant with eachother, but the rows will be similar.

I want to start a formula in Sheet one, that looks at the Letter in that same row, finds that Letter in Sheet two, and gets information from the same row but a few columns over. I might be explaining this poorly, so here's a picture of what i'm referring to. I'm trying to fill in F6 in Sheet 1 with information from F2 in Sheet 2. Would anyone be able to assist please? Is this even possible or would it need to be done through a macro? (If so what would you recommend)

Thank you very much

http://img8.imageshack.us/img8/4512/example2l.jpg

OK,

in sheet 1 you need this formula

=VLOOKUP($A6,'Sheet2'!$A$2:$F$100,6,FALSE)

this will work for 100 rows of data in sheet 2. Adjust the $F$100 part in above formula to suit your needs. You can copy and paste the formulas into the other cells of the column.

cheers

The formula

=VLOOKUP($A6,'Sheet2'!$A$2:$F$100,6,FALSE)

takes the value in A6 on sheet 1 and searches that value in the first column of the range A2:F100 on sheet 2. If the lookup value is found, it will return the value of the sixth column of the row where the value was found.

What exactly does not line up? can you post an example?

Glad to help. Can you please take the time to mark the thread as solved?