Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nested vlookup?
Hello,
I have too worksheets. One has SSN, Accident Date and Claim Number. The other just has SSN and Accident Date. I would like to pull claim number to the second sheet based on SSN and Accident date. In other words, I need Excel to check both the SSN and accident date. I was trying to use If and vlookup but I'm not having any luck. Any suggestions? Here is the general idea: Sheet 1 A B C 1 SSN Acc Date Claim Number 2 3 4 Sheet 2 A B 1 SSN Acc Date 2 3 4 |
#2
|
|||
|
|||
Hi
try the following type of array formula (entered with CTRL+SHIFT+ENTER): =INDEX('sheet1'!$C1:$C$100,MATCH(1,('sheet1'!$A$1: $A$100="SSN1")*('shee t1'!$B$1:$B$100="Account_date1"),0)) -- Regards Frank Kabel Frankfurt, Germany "astronautika" schrieb im Newsbeitrag ... Hello, I have too worksheets. One has SSN, Accident Date and Claim Number. The other just has SSN and Accident Date. I would like to pull claim number to the second sheet based on SSN and Accident date. In other words, I need Excel to check both the SSN and accident date. I was trying to use If and vlookup but I'm not having any luck. Any suggestions? Here is the general idea: Sheet 1 A B C 1 SSN Acc Date Claim Number 2 3 4 Sheet 2 A B 1 SSN Acc Date 2 3 4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Syntax Error | New Users to Excel | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions | |||
vlookup and IF function | Excel Worksheet Functions |