Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding the IF function to a VLOOKUP function.
I am trying to enter a VLOOKUP function into a formula. I need to add a IF
function to it. I have chatted with my professor and she sent me these instructions along with a sample worksheet. Here is what she said: You would want to use a VLOOKUP with the array referenced back to the columns in the sheet with the customer names. I am sending you an example. The main issue here is that we know the company will continue to add customers and sales, so we want to set the VLOOKUP array to use the columns rather than specific cell references. Also, it should be copied throughout the column in the second sheet. Notice that I have it set up with and IF function so that it will leave the name blank if there is no input in the cell for the client number. And here is the formula she sent: =IF(A1="","",VLOOKUP(Sheet2!A1,Sheet1!A:B,2)) I just can't seem to figure out how to make it work? HELP PLEASE!!!! -- Kristine |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding the IF function to a VLOOKUP function.
Be very careful with how your data is arranged when you use VLOOKUP. See
Excel help. If my intuition serves me well the quick fix is to do the following to your VLOOKUP: VLOOKUP(Sheet2!A1,Sheet1!A:B,2,FALSE) The FALSE will return exact matches and doesn't care if your data is ascending or not. If this helps please click "Yes" <<<<<<<<<< "Kristine" wrote: I am trying to enter a VLOOKUP function into a formula. I need to add a IF function to it. I have chatted with my professor and she sent me these instructions along with a sample worksheet. Here is what she said: You would want to use a VLOOKUP with the array referenced back to the columns in the sheet with the customer names. I am sending you an example. The main issue here is that we know the company will continue to add customers and sales, so we want to set the VLOOKUP array to use the columns rather than specific cell references. Also, it should be copied throughout the column in the second sheet. Notice that I have it set up with and IF function so that it will leave the name blank if there is no input in the cell for the client number. And here is the formula she sent: =IF(A1="","",VLOOKUP(Sheet2!A1,Sheet1!A:B,2)) I just can't seem to figure out how to make it work? HELP PLEASE!!!! -- Kristine |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding the IF function to a VLOOKUP function.
On which sheet and which column is the formula being entered?
Which sheet has the customer names? =IF(A1="","" is referring to which sheet? On Tue, 20 Oct 2009 07:52:01 -0700, Kristine wrote: I am trying to enter a VLOOKUP function into a formula. I need to add a IF function to it. I have chatted with my professor and she sent me these instructions along with a sample worksheet. Here is what she said: You would want to use a VLOOKUP with the array referenced back to the columns in the sheet with the customer names. I am sending you an example. The main issue here is that we know the company will continue to add customers and sales, so we want to set the VLOOKUP array to use the columns rather than specific cell references. Also, it should be copied throughout the column in the second sheet. Notice that I have it set up with and IF function so that it will leave the name blank if there is no input in the cell for the client number. And here is the formula she sent: =IF(A1="","",VLOOKUP(Sheet2!A1,Sheet1!A:B,2)) I just can't seem to figure out how to make it work? HELP PLEASE!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedded VLOOKUP function within IF function | Excel Worksheet Functions | |||
Adding a Macro to a VLookup Function | Excel Discussion (Misc queries) | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions |