An unsorted list in vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Need VLOOKUP to Work Two Ways 0
Vlookup and return sheet name also 2
matching from an unsorted list 1
Match and Vlookup issue 2
unsorted lookup 2
VLOOKUP returning formula 3
vlookup 1

Back
Top