What wrong with VLOOKUP formula

G

Guest

I have the following formula:

=VLOOKUP($B2,'Sheet 2'!C$1:C$771,5,'Sheet 2'!E$2:E$771)

for this case:

Sheet 1 Sheet 2

A B C D A B C D
E F G H I
XXX ? ? ? XXX 2 1 3

What's wrong?
I got VALUE!
 
B

Bob Phillips

VLOOKUP takes the form

=VLOOKUP(value_to_lookup,range_to_lookup,column_index,exact_approximate)

See help, you seem to be using incorrectly

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Need VLOOKUP to Work Two Ways 0
First column of range in VLOOKUP contains formula 2
VLOOKUP Function to return values in multipal Columns 6
Match a group of cells with another group of cells 1
Whether VLOOKUP can find Text 6
VLOOKUP formula 3
Combine data into central worksheet 1

Top