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
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