Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLookUpFnctnin Excell Sprdsheet
I have 2 sprdsheets & I know where to find VLookUp Fnctn, but I'm not sure
what to enter in every line; I need to 'Bump Up'-match the loan #s on my existing Excel Sprdsheet via using data from 2nd spreadsheet (column 1 (loan#s) & column 2(status of this loan#s). So new loan #s with their status will appear separately & the loan #s that match will show their new updated status. Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLookUpFnctnin Excell Sprdsheet
Assuming data on sheet1 starts in row 2...
=VLOOKUP(A2,'Sheet2'!A2:B100,2,FALSE) If a match is not found, this will return an error. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "nrva" wrote: I have 2 sprdsheets & I know where to find VLookUp Fnctn, but I'm not sure what to enter in every line; I need to 'Bump Up'-match the loan #s on my existing Excel Sprdsheet via using data from 2nd spreadsheet (column 1 (loan#s) & column 2(status of this loan#s). So new loan #s with their status will appear separately & the loan #s that match will show their new updated status. Thank you in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLookUpFnctnin Excell Sprdsheet
Hi,
If your loan #'s are in column A on both sheets and the status is in Column B then =IF(ISNA(VLOOKUP(A1,Sheet2!A$1:B$100,2,FALSE)),"", VLOOKUP(A1,Sheet2!A$1:B$100,2,FALSE)) or in 2007 =IFERROR(VLOOKUP(A1,Sheet2!A$1:B$100,2,FALSE),"") The first argument, A1, is the first cell with a loan number on sheet 1 The second argument, Sheet2!A$1:B$100, is the range where the loan#s and the status are entered The 3rd argument, 2, tells Excel you want the value to be returned from the second column of the range, the first column is always the column Excel checks for a match. The 4th argument, FALSE or 0 tells Excel that this is an Exact match not an approximant match. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "nrva" wrote in message ... I have 2 sprdsheets & I know where to find VLookUp Fnctn, but I'm not sure what to enter in every line; I need to 'Bump Up'-match the loan #s on my existing Excel Sprdsheet via using data from 2nd spreadsheet (column 1 (loan#s) & column 2(status of this loan#s). So new loan #s with their status will appear separately & the loan #s that match will show their new updated status. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto locking of excell workbook (excell 2003) | Excel Discussion (Misc queries) | |||
how do I set a button in a sprdsheet to email that sprdsheet to me | Excel Worksheet Functions | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
I need to be able to count the no. of times a sprdsheet is opened | Excel Discussion (Misc queries) | |||
I have user defined functions in sprdsheet. I want to put sprdsh. | Excel Worksheet Functions |