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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Help 1
VLookup Formula 5
Is this Vlookup 1
Excel Excel Vlookup formula based on cell data 7
Vlookup cell reference 6
VLookUp or other function to return matched data from multiple col 7
Replacement Vlookup Formula 2
Vlookup using multiple worksheets 2

Back
Top