Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Hi,
I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Hi,
It could be VLOOKUP or it could be INDEX Match. You would need to be more specific. Mike "Dave" wrote: Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Take a look at the LOOKUP and VLOOKUP functions in XL help, I believe one of
those is what you are looking for. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dave" wrote: Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Hi
I have one sheet with a reference number. I need to find that reference number in the other sheet and then return what name is next to that reference numberin the column next to it. Thanks "Mike H" wrote: Hi, It could be VLOOKUP or it could be INDEX Match. You would need to be more specific. Mike "Dave" wrote: Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Yes. Its lookup. doh! Thanks for your help!
"Luke M" wrote: Take a look at the LOOKUP and VLOOKUP functions in XL help, I believe one of those is what you are looking for. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dave" wrote: Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Hi
I thought I had it by using LOOKUP but this doesnt work!!! Any suggestions?? Thanks "Luke M" wrote: Take a look at the LOOKUP and VLOOKUP functions in XL help, I believe one of those is what you are looking for. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dave" wrote: Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Hi Mike
I thought I had this covered but it has not worked. I tried LOOKUP but it just returned random names. Thanks "Mike H" wrote: Hi, It could be VLOOKUP or it could be INDEX Match. You would need to be more specific. Mike "Dave" wrote: Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Sheet1 has your list of reference numbers, from A2 to A100.
Sheet2 has the datalist, with the numbers in say D1 to D75. NOW, if the names are in a column to the *right* of the numbers, say E1 to E75, you could use the Vlookup() function. Enter this on Sheet1, in B2: =Vlookup(A2,Sheet2!D$1:E$75,2,0) And copy down. If, on the other hand, the names in the datalist on Sheet are to the *left* of the numbers, say C1 to C75, then use the Index() Match() combination in B2 of Sheet1: =Index(Sheet2!C$1:C$75,Match(A2,Sheet2!D$1:D$75,0) ) And copy down. You could of course use the Index/Match combo in the first case also, but now you have exposure to different approaches. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === .. "Dave" wrote in message ... Hi Mike I thought I had this covered but it has not worked. I tried LOOKUP but it just returned random names. Thanks "Mike H" wrote: Hi, It could be VLOOKUP or it could be INDEX Match. You would need to be more specific. Mike "Dave" wrote: Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND COLUMN DATA
Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble If this doesn't help, you're going to have to provide some details. What value is being matched? Where is the column that should be matched? Where is the column that should be returned? Dave wrote: Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find last column with data? | Excel Discussion (Misc queries) | |||
compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
find the data of the corresponding column | New Users to Excel | |||
Find Last data in a column | Excel Worksheet Functions | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) |