Saturday, 19 October 2013

Use Search command in Vlookup

Vlookup can also pick the like fields – here is the command

 

 

Search

Name

ID

DOB

Team

eo

Vikram Deo

0012327

12/12/2012

1

 

Search

Name

eo

=VLOOKUP("*"&H2&"*",'Employee List'!$A$2:$D$11,1,0)

 

No comments:

Post a Comment