VLOOKUP

P

PAL

I am using VLOOKUP as I have many times in the past. The formula I am using
is:

=VLOOKUP($A3,Raw,2,FALSE)

It returns a "0" presumeably becasue it thinks the value in column 2 is "0".
It returns the same thing regardless of the column, with one exception,
column 1. It returns that value appropriately. The format for the columns
vary between numbers, texts, dates.

Thanks in advance
 
D

Dave Peterson

You'll see that 0 if the "sending" cell is empty.

My guess is that the "sending" cell contains 0 or is empty AND there's a match
higher in the range that you're not noticing.

Or maybe Raw isn't the range you expected it to be.

You may want to share what's in $a3, too.
 
T

Tom Hutchins

What is your question? From your example, "Raw" must be a named range
spanning at least two contiguous columns. The value you are matching (from
A3) must be in the leftmost column of the range "Raw", and the value to be
returned must be in the second column of the range "Raw".

Hope this helps,

Hutch
 

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

Top