Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using If fuction and vlookup with list
I have a table where I have my list and it is in a deferent work sheet. When
a user selects something from the list I want to match it with my table and return a number in a different cell. I have tried this formula. =IF(D5="","",VLOOKUP(D5,Table!A:B,2,FALSE)) It will work for this cell now I want to return a different number in column C I try to change B to C but it only returns the number in B. What do I need to do? Thanks for the help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using If fuction and vlookup with list
Remember to increase the size of the lookup table to at least 3 columns (A:C):
=IF(D5="","",VLOOKUP(D5,Table!A:c,3,FALSE)) Larry wrote: I have a table where I have my list and it is in a deferent work sheet. When a user selects something from the list I want to match it with my table and return a number in a different cell. I have tried this formula. =IF(D5="","",VLOOKUP(D5,Table!A:B,2,FALSE)) It will work for this cell now I want to return a different number in column C I try to change B to C but it only returns the number in B. What do I need to do? Thanks for the help -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using If fuction and vlookup with list
Try
=IF(D5="","",VLOOKUP(D5,Table!A:C,3,FALSE)) i.e. expand the table to inculde column C <Table!A:C and change the column index from 2 (for B) to 3 (fro C). Hope that is what you wanted. "Larry" wrote: I have a table where I have my list and it is in a deferent work sheet. When a user selects something from the list I want to match it with my table and return a number in a different cell. I have tried this formula. =IF(D5="","",VLOOKUP(D5,Table!A:B,2,FALSE)) It will work for this cell now I want to return a different number in column C I try to change B to C but it only returns the number in B. What do I need to do? Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using If fuction with vlookup from list | New Users to Excel | |||
Min Fuction | Excel Worksheet Functions | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Vlookup fuction | Excel Worksheet Functions | |||
need a fuction that can do this (or can it be done) | Excel Worksheet Functions |