Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
I am using VLOOKUP to pull data from another spreadsheet.
I have a list of staff names on each spreadsheet - and use VLOOKUP in worksheet 1 to find the names in worksheet 2. But I have additional names in worksheet 1 that do not appear in worksheet 2. If those names don't appear in worksheet 2 - I want VLOOKUP to enter a 0 in my column of data in worksheet 1. How do I do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
=IF(ISNA(VLOOKUP(<your parameters)),0,VLOOKUP(<Your parameters))
-- Hth Kassie Kasselman Change xxx to hotmail "Help" wrote: I am using VLOOKUP to pull data from another spreadsheet. I have a list of staff names on each spreadsheet - and use VLOOKUP in worksheet 1 to find the names in worksheet 2. But I have additional names in worksheet 1 that do not appear in worksheet 2. If those names don't appear in worksheet 2 - I want VLOOKUP to enter a 0 in my column of data in worksheet 1. How do I do that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
I'm still having trouble with this. Here's what I have entered:
=IF(ISNA(VLOOKUP(B23,'Sheet 2'!21:127,6)),0,VLOOKUP(B23,'Sheet 2'!21:127,6)) B23 - is the staff member's name I am searching for - and I want to insert whatever data is in column 6 on Sheet 2. But if the staff member's name is not on Sheet 2 - it still puts data in there - and I want it to read 0 - if the staff member's name is not on Sheet 2. "Kassie" wrote: =IF(ISNA(VLOOKUP(<your parameters)),0,VLOOKUP(<Your parameters)) -- Hth Kassie Kasselman Change xxx to hotmail "Help" wrote: I am using VLOOKUP to pull data from another spreadsheet. I have a list of staff names on each spreadsheet - and use VLOOKUP in worksheet 1 to find the names in worksheet 2. But I have additional names in worksheet 1 that do not appear in worksheet 2. If those names don't appear in worksheet 2 - I want VLOOKUP to enter a 0 in my column of data in worksheet 1. How do I do that? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
by omitting the fourth argument, you are performing an approximate match
lookup. you probably want an exact match lookup: VLOOKUP(B23,'Sheet 2'!21:127,6, FALSE) "Help" wrote: I'm still having trouble with this. Here's what I have entered: =IF(ISNA(VLOOKUP(B23,'Sheet 2'!21:127,6)),0,VLOOKUP(B23,'Sheet 2'!21:127,6)) B23 - is the staff member's name I am searching for - and I want to insert whatever data is in column 6 on Sheet 2. But if the staff member's name is not on Sheet 2 - it still puts data in there - and I want it to read 0 - if the staff member's name is not on Sheet 2. "Kassie" wrote: =IF(ISNA(VLOOKUP(<your parameters)),0,VLOOKUP(<Your parameters)) -- Hth Kassie Kasselman Change xxx to hotmail "Help" wrote: I am using VLOOKUP to pull data from another spreadsheet. I have a list of staff names on each spreadsheet - and use VLOOKUP in worksheet 1 to find the names in worksheet 2. But I have additional names in worksheet 1 that do not appear in worksheet 2. If those names don't appear in worksheet 2 - I want VLOOKUP to enter a 0 in my column of data in worksheet 1. How do I do that? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
Thanks JMB! That was a serious slip on my part!
Help. I notice that you did not include columns? Something like =IF(ISNA(VLOOKUP(B23,'Sheet 2'!A21:F127,6,FALSE)),0,VLOOKUP(B23,'Sheet 2'!A21:F127,6,FALSE)) is closer to the truth. Vlookup needs to know where to look! -- Hth Kassie Kasselman Change xxx to hotmail "JMB" wrote: by omitting the fourth argument, you are performing an approximate match lookup. you probably want an exact match lookup: VLOOKUP(B23,'Sheet 2'!21:127,6, FALSE) "Help" wrote: I'm still having trouble with this. Here's what I have entered: =IF(ISNA(VLOOKUP(B23,'Sheet 2'!21:127,6)),0,VLOOKUP(B23,'Sheet 2'!21:127,6)) B23 - is the staff member's name I am searching for - and I want to insert whatever data is in column 6 on Sheet 2. But if the staff member's name is not on Sheet 2 - it still puts data in there - and I want it to read 0 - if the staff member's name is not on Sheet 2. "Kassie" wrote: =IF(ISNA(VLOOKUP(<your parameters)),0,VLOOKUP(<Your parameters)) -- Hth Kassie Kasselman Change xxx to hotmail "Help" wrote: I am using VLOOKUP to pull data from another spreadsheet. I have a list of staff names on each spreadsheet - and use VLOOKUP in worksheet 1 to find the names in worksheet 2. But I have additional names in worksheet 1 that do not appear in worksheet 2. If those names don't appear in worksheet 2 - I want VLOOKUP to enter a 0 in my column of data in worksheet 1. How do I do that? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
No - you didn't slip. Wasn't really enough detail regarding the formula the
OP was using until now. However, vlookup seemed to work okay for me using only row references (I've never used entire row references with vlookup so it appeared a little odd to me as well). "Kassie" wrote: Thanks JMB! That was a serious slip on my part! Help. I notice that you did not include columns? Something like =IF(ISNA(VLOOKUP(B23,'Sheet 2'!A21:F127,6,FALSE)),0,VLOOKUP(B23,'Sheet 2'!A21:F127,6,FALSE)) is closer to the truth. Vlookup needs to know where to look! -- Hth Kassie Kasselman Change xxx to hotmail "JMB" wrote: by omitting the fourth argument, you are performing an approximate match lookup. you probably want an exact match lookup: VLOOKUP(B23,'Sheet 2'!21:127,6, FALSE) "Help" wrote: I'm still having trouble with this. Here's what I have entered: =IF(ISNA(VLOOKUP(B23,'Sheet 2'!21:127,6)),0,VLOOKUP(B23,'Sheet 2'!21:127,6)) B23 - is the staff member's name I am searching for - and I want to insert whatever data is in column 6 on Sheet 2. But if the staff member's name is not on Sheet 2 - it still puts data in there - and I want it to read 0 - if the staff member's name is not on Sheet 2. "Kassie" wrote: =IF(ISNA(VLOOKUP(<your parameters)),0,VLOOKUP(<Your parameters)) -- Hth Kassie Kasselman Change xxx to hotmail "Help" wrote: I am using VLOOKUP to pull data from another spreadsheet. I have a list of staff names on each spreadsheet - and use VLOOKUP in worksheet 1 to find the names in worksheet 2. But I have additional names in worksheet 1 that do not appear in worksheet 2. If those names don't appear in worksheet 2 - I want VLOOKUP to enter a 0 in my column of data in worksheet 1. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |