Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. =VLOOKUP(What to search for, Range to look in,
  2. what range column number to return, search type)
  3.  
  4. =VLOOKUP(E2,$B$2:$C$6,2,0)
  5.  
  6. =IF(E2="","",VLOOKUP(E2,$B$2:$C$6,2,0))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement