| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match, Index, Vlookup, If (confused)
Thank you very very much for the formula!
"Govind" wrote: Hi, Use =IF(ISERROR((VLOOKUP(A2,Sheet1!$A$2:$B$5,2,FALSE)) ),0,(VLOOKUP(A2,Sheet1!$A$2:$B$5,2,FALSE))) and copy it down. Here A2 is the cell where 'John' is in Worksheet 2. Regards Govind. PJS wrote: Hi everyone. I am not sure which commands to use, can someone please show me how to accomplish this? I have two different worksheets Worksheet 1 Worksheet 2 Name Total Name Total Abe 3 John Bob 4 Jane Charlie 5 Bob I would like to compare the names in column A (worksheet 1) vs. the names in colum A (worksheet 2), if they match, in this case Bob, return the value 4 in worksheet 2. For John and Jane, since no matches are found, return the value 0. Is this possible and what commands are needed? Thank you, Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function Vlookup, Match or Index? | Excel Worksheet Functions | |||
| Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
| Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
| Vlookup, index, match? | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Hybrid Mode
