Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and If functions
Worksheet 1 and 2 have student ID numbers in column 1 to identify the
records. I am trying to use the ID number to look up information in worksheet 2 and have it placed in a specific cell in worksheet 1. If the ID number is not contained in worksheet 2 I would like the function to remain blank or to place the number zero in the cell. If the ID number is located in worksheet 2 then I want the function to return the value in the corresponding column 2. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and If functions
Refer help on VLOOKUP..
Try the below formula in Sheet1 with unique id in sheet1 A1... =VLOOKUP(A1,sheet2!A:B,2,0) 'modified to handle no matches =IF(ISNA(VLOOKUP(A1,sheet2!A:B,2,0)),"",VLOOKUP(A1 ,sheet2!A:B,2,0)) If this post helps click Yes --------------- Jacob Skaria "Robin Reid" wrote: Worksheet 1 and 2 have student ID numbers in column 1 to identify the records. I am trying to use the ID number to look up information in worksheet 2 and have it placed in a specific cell in worksheet 1. If the ID number is not contained in worksheet 2 I would like the function to remain blank or to place the number zero in the cell. If the ID number is located in worksheet 2 then I want the function to return the value in the corresponding column 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
$ for VLOOKUP functions | Excel Worksheet Functions | |||
Help with Vlookup and MAX functions | Excel Worksheet Functions | |||
VLOOKUP and IF Functions | Excel Worksheet Functions | |||
if and vlookup functions | New Users to Excel | |||
How do I add vlookup functions together | Excel Discussion (Misc queries) |