Trouble with vsearch function

  • Thread starter Thread starter polo
  • Start date Start date
P

polo

I am using a Vsearch function in a report workbook. The data is on
another woorkbook. The function finds the data I am looking for in the
data range, but it doesn't retreive the right information.... Rather it
gives the data in the cell just above the one I want.

It would also help me if someone could tell me how to format a column
so that data imported as text becomes value (So that all the numbers
that are stuck in the left of the cells move to the right as captured
value)

Sorry if some of this isn't very clear...
Thank you for your help
 
Polo,

First question,
If by Vsearch you mean VLOOKUP, I suggest you read Excel Help about that function carefully. The answer is there, I'm sure.

Second question,
Your imported numbers appear as text?
- select the problem cells
- do Format>Cells>Number
- copy any empty cell
- select the problem cells
- do Paste Special>Add

HTH
Anders Silvén
 
Assuming that you are using VLOOKUP, are you using the fourth argument TRUE
or FALSE ?
=VLOOKUP(Look For, Look In, Show column number, TRUE) will find the nearest
match,
=VLOOKUP(Look For, Look In, Show column number, FALSE) will find an exact
match, and if no exact match exists will return #N/A
 
Back
Top