I have a master membership list which amongst everything else has a column of membership numbers. Another spreadsheet of just membership numbers and their membership swipe card number. Is there some way that I can use the member ship numbers to populate the card number field in the master spreadsheet? not all members have cards.
Many thanks
Peter
Have you looked at the VLOOKUP function?
Bookmarks