Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up same value
Good evening- I am trying to take two lists and finding the matching values
on both lists. I have tried using vlookup, but haven't had much luck. Is that the right function to use? What is the difference between vlookup and lookup? Here is what I've got- two worksheets (A and B). =VLOOKUP(B4,B!B:B,2,FALSE) Any help would be greatly appreciated! Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up same value
Try the below..I hope you are trying to retrieve the same value ...The third
argument is the number of column in the mentioned range...Here B:B has got only one column =VLOOKUP(B4,B!B:B,1,FALSE) Or =IF(ISERROR(MATCH(B4,B!B:B,0)),"Not in list","Found") If this post helps click Yes --------------- Jacob Skaria "SMH" wrote: Good evening- I am trying to take two lists and finding the matching values on both lists. I have tried using vlookup, but haven't had much luck. Is that the right function to use? What is the difference between vlookup and lookup? Here is what I've got- two worksheets (A and B). =VLOOKUP(B4,B!B:B,2,FALSE) Any help would be greatly appreciated! Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up same value
Try this:
List1 in the range Sheet A A1:A10 List2 in the range Sheet B A1:A10 Enter this formula on Sheet A B1: =IF(COUNTIF(B!A$1:A$10,A1),"x","") Copy down as needed. Cells that return "x" denote a match. If one list is shorter than the other then compare the shorter list against the longer list. -- Biff Microsoft Excel MVP "SMH" wrote in message ... Good evening- I am trying to take two lists and finding the matching values on both lists. I have tried using vlookup, but haven't had much luck. Is that the right function to use? What is the difference between vlookup and lookup? Here is what I've got- two worksheets (A and B). =VLOOKUP(B4,B!B:B,2,FALSE) Any help would be greatly appreciated! Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up same value
Hi,
Here is a way to color the items which or on both lists, suppose list1 is in C1:C100 and list2 in F1:F200 In 2003: 1. Select the cells you want to format, in this case C1:C100 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =COUNTIF(F$1:F$200,C1) 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =COUNTIF(F$1:F$200,C1) 5. Click the Format button and choose a format. 6. Click OK twice Repeat the same idea after selecting F1:F200. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "SMH" wrote: Good evening- I am trying to take two lists and finding the matching values on both lists. I have tried using vlookup, but haven't had much luck. Is that the right function to use? What is the difference between vlookup and lookup? Here is what I've got- two worksheets (A and B). =VLOOKUP(B4,B!B:B,2,FALSE) Any help would be greatly appreciated! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|