vlookup or IF

  • Thread starter Thread starter dhollyholman
  • Start date Start date
D

dhollyholman

Hi I have a spreadsheet which contains data, in simplified form as
A Name B Ref
Another spreadsheet which has only name
I need to get the reference which matches the name on both sheets into a new
column. Which is the best way of doing this?
Many thanks--
Denise
 
Use Vlookup...Make sure to put false at the end like the example formula
below. This ensures that it is an EXACT match, instead of a close match.

=VLOOKUP(A6,'Design Review Log'!G:H,2,FALSE)
 
Back
Top