Pivot table or Vlookup or how?

BlueSky · #1 02-19-2015, 08:02 AM

Quote:

Originally Posted by gebobs

Yeah, a VLOOKUP will do that easily.

=VLOOKUP(objtable1, table2, 3, false)
=VLOOKUP(objtable1, table2, 4, false)

Wow I will have to try that do both data sets have to be in the same workbook on different sheets or can you link to a different workbook? I'm not sure about that side of things. Thank you for your input at least now I know it can be done.

gebobs · #2 02-19-2015, 09:53 AM

Quote:

Originally Posted by BlueSky

do both data sets have to be in the same workbook on different sheets or can you link to a different workbook?

All are possible.

BlueSky · #3 02-19-2015, 10:30 AM

Quote:

Originally Posted by gebobs

All are possible.

That is such good news, thank you so much, I had to find out before spending all the time learning how to do it!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table Question- Can the table display in the order the boxes were checked/selected?	blackjack	Excel	0	09-13-2014 08:57 PM
Pivot table help	TishyMouse	Excel	2	04-27-2012 10:19 AM
pivot table	aliasadi_07	Excel	1	03-11-2012 12:49 AM
Help with a pivot table please!	natsha	Excel	1	02-16-2012 12:41 PM
Pivot Table	Karen615	Excel	5	08-03-2011 10:46 AM