Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LOOKING UP A TABLE/SHEET AND MATCH FOR A STRING OR NUMBER
I have two workheets. "WORKSHEET ONE" has a list of LAST names in column A.
"WORKSHEET TWO" has a list of names last names and first names. Lastnames are in column A and first names in column B. What I want to do is look up the last names in worksheet TWO and whenever there is a match in worksheet ONE move the correstponding first name to column B of worksheet A. I have tried all the LOOKUP functions but the problem that I have is that I want it only to work when there is an EXACT match! Can this be done if so how. Thank you! |
#2
|
|||
|
|||
Hi Charles
use VLOOKUP in B2 of sheet1 =VLOOKUP(A2,Sheet2!$A$1:$B$100,2,0) this will give you the information where there is an exact match -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Charles" wrote in message ... I have two workheets. "WORKSHEET ONE" has a list of LAST names in column A. "WORKSHEET TWO" has a list of names last names and first names. Lastnames are in column A and first names in column B. What I want to do is look up the last names in worksheet TWO and whenever there is a match in worksheet ONE move the correstponding first name to column B of worksheet A. I have tried all the LOOKUP functions but the problem that I have is that I want it only to work when there is an EXACT match! Can this be done if so how. Thank you! |
#3
|
|||
|
|||
Try this:
With datalist in A2:B20 on Sheet2 And A2:A20 on Sheet1, Enter this in B2 of Sheet1, and drag down to copy: =VLOOKUP(A2,Sheet2!$A$2:$B$20,2,0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Charles" wrote in message ... I have two workheets. "WORKSHEET ONE" has a list of LAST names in column A. "WORKSHEET TWO" has a list of names last names and first names. Lastnames are in column A and first names in column B. What I want to do is look up the last names in worksheet TWO and whenever there is a match in worksheet ONE move the correstponding first name to column B of worksheet A. I have tried all the LOOKUP functions but the problem that I have is that I want it only to work when there is an EXACT match! Can this be done if so how. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Match Function arguments | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |