VLOOKUP Issue

Hello people,

Just a quick question on VLOOKUP.

Firstly, I have a list of names that I'm looking up, and I want to list the data relevant to each name in a seperate place using a VLOOKUP ,(maybe theres a better way to do it) but some of the names appear more than once, resulting in an error.

I have on the first sheet, Name, Customer, Amount and Variance.

On the seperate sheet (in the same workbook) I have then name with 4 VLOOKUPS underneath, trying to extract the data Customer, Amount and Variance. But, I get errors in all of them.

Is there anyway I can List all the data relevant to each name using a Lookup function or is there another formula I should be using?

Thank you,

NJT.

Hi,

post a workbook with an example of your data and we can sort it out.

If you use VLOOKUP with FALSE as the last parameter, your lookup list must be sorted. If it is not sorted, your last parameter should be set to FALSE, then VLOOKUP finds approximate matches, too.

HTH

teylyn .. dont you mean true?

If you use VLOOKUP with FALSE as the last parameter, your lookup list must be sorted

martin,

'f course, Sorry, I got it mixed up.