Hi
In the sheet attatched along the tabs ther is names, mattg1 matt2, amy........ In the last colum (f) i want it to read the row i2 to i372 in a vlookup style as the other rows do on the tab mattg1, mattg2 etc...... from the main score sheet as i am no good at this vlookup stuff
can anyone help asap
Matt
Last edited by matkalg; 07-03-2010 at 06:27 AM. Reason: not correct title
Try this in F2, then copy down:
=IF(ISNA(VLOOKUP(A2,'Main Score Sheet'!A:I,9,FALSE)),"",VLOOKUP(A2,'Main Score Sheet'!A:I,9,FALSE))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks