Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
whats wrong with Vlookup 2
- Thread starter Cpreston
- Start date
SkipVought
Programmer
Column H header should be Callee Name. Notice that there are 2 columns of Numbers, a Caller and Callee. Both can have an associated Name, depending on which Call Number is referenced and theoretically a Caller could also be a Callee and visa versa.
So given those assumptions, your Call Name Table (columns I:J) which ought to not be contiguous with your Call Transactions Table (columns A:H) as they will have a different number of rows as your example demonstrates, your Call Name Table could include either Caller/Callee Numbers and Names and your Call Transaction Table could be expanded to include a column for Caller Name along with Callee Name.
These are general assumptions that may not fit your specific application. They are questions that I would raise if I were involved with identifying the data entities and database design.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...
for a NUance!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!
So given those assumptions, your Call Name Table (columns I:J) which ought to not be contiguous with your Call Transactions Table (columns A:H) as they will have a different number of rows as your example demonstrates, your Call Name Table could include either Caller/Callee Numbers and Names and your Call Transaction Table could be expanded to include a column for Caller Name along with Callee Name.
These are general assumptions that may not fit your specific application. They are questions that I would raise if I were involved with identifying the data entities and database design.
Skip,
[sub]
Just traded in my OLD subtlety...for a NUance!
[/sub]"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!
- Status