An unsorted list in vlookup

G

Guest

Can someone tell me the rules of lists used in vlookup?

I have two sheets with the same, unsorted list (sorted differently in both
sheets). I would like to use these list for the vlookup-formula, and when the
reference I use is on the top of the list (in the formula), it doens't return
the correct value (0).

Is there any solution to this without me having to add an empty row for each
new sheet or to do the actual sorting before I can use this formula?
 
A

Alan

Use the fourth argument in VLOOKUP and set it to FALSE eg
=VLOOKUP(D3,H1:K20,2,FALSE)
Regards,
Alan.
 

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

Auto sort help. 2
matching from an unsorted list 1
unsorted lookup 2
Match and Vlookup issue 2
Vlookup and return sheet name also 2
Find first occurence in a list that's greater than a specific num 2
Counting frequency in unsorted data 2
ISERROR on VLOOKUP 3

Top