lookup formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the Lookup formula to lookup information from one column
and match it with information with another. I then choose a result column to
diplay in my formula field. what is happening is the number being looked up
is defaulting to a number less than it and giving that answer. I used this
formula recently without problems but now for some reason it doesn't work.
this is the formula I use (=LOOKUP(D$2:D$2225,A$2:A$352,B$2:B$352). I hope
this make since.
 
Look in help for the VLOOKUP function, set range lookup to FALSE or 0 to
find exact match
 
Can you give me an example, currently I am using just lookup. How would I
use it with vlookup?
 
You must log in or register to reply here.

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
With F1 value, look at A, if match or partial match return B 5
Lookup returning wrong results 0
DateRange Lookup no exact match, can't use lesser 4
Help needed 0
What type of "lookup" 3
lookup/match mult values 3
Problem with a Array formula, Please help !! 6

Back
Top