Re: Excel Question
Two columns and use the 'Find' feature?
Two columns and use the 'Find' feature?
G H
1 PASSPHRASE NAME
2 DC453 Ken Gold
3 JG467 John Blow
4 AB952 Rich Bigg
5 BR549 Junior Samples
A B
1 NAME PASSPHRASE
2 JG467
=VLOOKUP(B2,G1:H5,2,FALSE)