Please Help !!!

  • Thread starter Thread starter locutus243
  • Start date Start date
L

locutus243

A vlookup tool normally looks up from one field and then returns a value
based on the information in this field.

Does anyone know if it is possible, how it is possible and would be
able to give me an example of how a vlookup (or any function can be
used) to lookup from two fields and then return a value.

i.e. In a fantasy football scenario, rather than looking up a player
code and getting the relevant information returned. I want to get a
player code, cross reference this to check that the correct club is
listed, then return the relevant information.

Any help would be much obliged and could actually stop suicide if this
stupid unanswerable tangent persists to outfox me !!!!!!

Thanx
 
Hi
use a array formula like the following (entered with
CTRL+SHIFT+ENTER):
=INDEX(C1:C100,MATCH(1,(A1:A100=value1)*
(B1:B100=value2),0))
 
You must log in or register to reply here.

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

Formula Help 3
VLOOKUP on partial lookup_value 7
VLOOKUP forumla for Excel HELP! 1
Vlookup? Questions about answer I got??? Help, please. 2
Vlookup Help 3
Vlookup function returns duplicate values 5
Vlookup Formula Help 3
Vlookup to return the next true value 2

Back
Top