I need to do a function like VLOOKUP but two colums of data needt to match, then return
the data from the third column.
I have a look up table in this format:
Last Name|First Name| Org|
The spreadsheet being loaded with "ORG" info
has the same format, but there are multiple
entries of last & first names.
I cannot use the standard VLOOKUP because I
have people with the same last names, or the
same first names. ie: I need to match both
before the "ORG" is laoded to the spreadsheet.
Any help would be appreciated.
the data from the third column.
I have a look up table in this format:
Last Name|First Name| Org|
The spreadsheet being loaded with "ORG" info
has the same format, but there are multiple
entries of last & first names.
I cannot use the standard VLOOKUP because I
have people with the same last names, or the
same first names. ie: I need to match both
before the "ORG" is laoded to the spreadsheet.
Any help would be appreciated.