Vlookup Easy Question

C

comotoman

Can vlookup search for multiple values?

example: =vlookup(b6:b25,c1:g100,3,false)

This is what I need to happen, but it doesnt work.
 
C

comotoman

if that cant be done, can i group the formula:

=vlookup(b2,c2:h59,3,false)vlookup(b3,c2:h59,3,false)

How can i do this
 
C

comotoman

sheet 1

a6=vlookup(f1:f5,'sheet2'!a1:h20,2,false)

f1 "101" The prefix '10' is a month number, the remainder is the day
number.
f2 "102"
f3 "103"
f4 "104"
f5 "105"

Sheet 2

A1:A20 Dates converted to 'mmd'
b1:b20 Job name

On sheet 1 I need to find all the jobs from the desired search, and
list them accordingly in cells a6:a100, with my list showing no empty
rows. (done with advanced filter)
 
D

Domenic

First you'll need to make sure that the data entered in F1:F5 and A1:A20
are in the same format. Either enter true date values, which can be
formatted as you like, or format the cells as 'Text' and enter your
dates in the following manner...

0101 ---> for January 1st

and

1031 ---> for October 31st

Then, on Sheet2...

C1: Leave empty

C2: =ISNUMBER(MATCH(A2,Sheet1!$F$1:$F$5,0))

Lastly, using Advanced Filter, try the following...

1) Start from Sheet1 by clicking on the sheet tab

2) Data > Filter > Advanced Filter

Check 'Copy to another location'

List range: Sheet2!$A$1:$B$20 (which includes the header)

Criteria range: Sheet2!$C$1:$C$2

Copy to: Sheet1!$A$6

Click Ok

Hope this helps!
 
Top