Vlookup

  • Thread starter Thread starter budlink
  • Start date Start date
B

budlink

I have a list of user names (data) in a worksheet this list als
contains their full name. I also have a list with the (List) Full nam
and address in another worksheet. What formula do I use to match th
full name and place their user name in a column next to their real nam
in the list worksheet
 
budlink > said:
I have a list of user names (data) in a worksheet this list also
contains their full name. I also have a list with the (List) Full name
and address in another worksheet. What formula do I use to match the
full name and place their user name in a column next to their real name
in the list worksheet.
Click to expand...

Suppose Sheet1 contains the full names in B1:B99 and the user names in
D1:D99.
Suppose also that in Sheet 2 you have a full name in F1 and want to return
the corresponding user name into G1. In G1 you would put the formula
=VLOOKUP(F1,Sheet1!B1:D99,3,FALSE)
This looks up F1 in the first column of B1:D99 (i.e. B) and returns the
corresponding data from the third column of that range (i.e. D).

If your user names are to the left of the full names in Sheet1, you cannot
use VLOOKUP but would need to combine INDEX and MATCH. Post back if this is
the case.
 
budlink said:
*I have a list of user names (data) in a worksheet this list als
contains their full name. I also have a list with the (List) Ful
name and address in another worksheet. What formula do I use to matc
the full name and place their user name in a column next to thei
real name in the list worksheet. *
Click to expand...

Hi,

In what format are the Full Name and Address presented in the 2n
Workbook.
i.e. are they in different cells.
Could you give a brief description of this please.

Regards

Ian Ma
 
Back
Top