|
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? |
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 10:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com