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.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=473435

Tried entering it as an array formula? (Press Ctrl+Shift+Enter).


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=473435

Good idea, but i can still not get it to work.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=473435

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

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

How can i do this?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=473435

Can you provide a small sample of your data along with your expected
results?

In article ,
comotoman
wrote:

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.

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)


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=473435

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!

In article ,
comotoman
wrote:

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)