Thread: vlookup or IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default vlookup or IF

VLOOKUP


"dhollyholman" wrote:

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