Arrrgh!!

[Lynwood]

Hi All!
I have spent a good part of my day combing through this site looking for an answer so I wouldn't have to ask...

Is there an easier way to combine these two darn sheets??

I know the info on these isn't great, but it's all I have to work with and it doesn't get any better than that.

[VBA Noob]

Hi,

A Vlookup might help in Cell H3 on the sheet ending 010207 enter

=VLOOKUP($C3,'[Pentax Frame OR 2.xls]FRAME'!$A:$F,COLUMN(A1),FALSE)

drag across to M3 and down the range. Paste special values if required

More help on lookups on the attached link

http://www.contextures.com/xlFunctions02.html

VBA Noob

[Lynwood]

thank you so much! i've been to that link, don't laugh but i think i need it "dumbed down" a bit more....

[VBA Noob]

try this

VBA Noob

[Lynwood]

that totally helps!
sometimes i need to be spoken to like a 4 year old. although, i'm thinking i could've asked my 4 year old for help....

[VBA Noob]

Glad it helped

VBA Noob