I currently have a report that gives me the data i need onto 2 spreadsheets.
The one i have attached is where i need the latest comments transferring to the other spreadsheet.
Column A Provides the Scheme Number - Same on both sheets
Column B Provides a Ref Number to the Comments in Column J, which i need to put the latest one into the next available column in the first sheet.
I've tried VLOOKUP's to no avail.
Please Help
Last edited by VBA Noob; 01-28-2009 at 09:19 AM.
Should look something like...
that.
=VLOOKUP($A2,'[Testing(1).xls]Sheet1'!$A$2:$B$14,2)
If you're looking up based on column A, and returning results in column B.
Note that VLOOKUP must have the - searched through - column sorted in ascending order to function properly.
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks