Member Avatar for masterjiraya

I dont know where to post it, but this is the reliable help from geeks I've known for several years
Problem:
I have a version of 2003 of MS EXCEL

for example I have Line A and Line B in the same work sheet

the DATA of Line A has a b c d e and f

the data of Line B has b and d only

if I use this formula Vlookup($A:$A,$B:$B,1,FALSE), it returns b and d in line C but what I want is th the a c e and f

how would I do that.

in discerete Mathematics, vlookup() is the INTERSECTION of 2 sets but what I want is NOT the INTERSECTION of two sets

in my original formula, it has a wild card ( meaning to say... ""&$A:$A&"" was used in vlookup)

Edited by pritaeas because: Moved.
  • 2 Contributors
  • 1 Reply
  • 168 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by Mike Askew
Member Avatar for Mike Askew

Could just be posted to the software development main forum, and tag it appropriately, as Daniweb is moving towards tagging.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.