G
Guest
when I use vlookup the function returns the value from the correct column but
from the row above the row with the search match. what am i doing wrong?
from the row above the row with the search match. what am i doing wrong?
DJC said:when I use vlookup the function returns the value from the correct column
but
from the row above the row with the search match. what am i doing wrong?
DJC said:Rob: Yes I have, I'm only getting a value when I leave that variable off
or
when it's true, false gave me #N/A. I also tried lookup and have the same
issue with thaat function in that it returns a value from the right column
but from the row above the match row. Thanks. Dave
DJC said:Rob: I appreciate your response. I believe I understand vlookup from a
syntax and set up perspective. What I don't understand is what would
cause
the function to find the match on row 20 for instance and return the
required
value from row 19. Please attempt to address that issue. Thanks.
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.