On the attached spreadsheet, i am trying lookup the selection name in column A on the summary sheet and search through column A of the other three worksheets adding together the three answers but something isn't working as the end answer is incorrect.
I have tried vlookup and also tried combining offset/match but neither way i am getting the correct answer.
I removed a lot of the data to simplify things and changed the figures to fictional ones for privacy reasons.
Thanks.
Last edited by adam2308; 04-16-2009 at 03:42 PM.
This works:
you forgot to the FALSE argument in the second and third Vlookups.
=VLOOKUP(A3,'Ante-Post'!A2:D132,4,FALSE)+VLOOKUP(A3,NRNB!A2:D89,4,FALSE)+VLOOKUP(A3,DOR!A2:F46,6,FALSE)
Also, you will get #N/A because your matches in columns A in each sheet don't exactly match... for e.g. Butlers Choice had an extra space in one sheet and on the other sheet had an apostrophe in Butler's....
They must be exact matches...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks. I never noticed the spaces and apostrophy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks