| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using If fuction with vlookup from list
Im working with a list in one worksheet and I have the table list in another
worksheet. I want to return a value from the table based on the list selection. I have written this formula. =IF(D5="","",VLOOKUP(D5,Table!A:B,2,FALSE)) and it returns data from B that match A. Now in another cell I want to return data from C and when I change B to C it still return data from B not C. How can I get data from C that matches data from my list? Thanks for the help. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
using If fuction with vlookup from list
You must change the column index number from 2 to 3
=IF(D5="","",VLOOKUP(D5,Table!A:C,3,FALSE)) Gord Dibben MS Excel MVP On Tue, 7 Oct 2008 12:50:28 -0700, Larry wrote: I’m working with a list in one worksheet and I have the table list in another worksheet. I want to return a value from the table based on the list selection. I have written this formula. =IF(D5="","",VLOOKUP(D5,Table!A:B,2,FALSE)) and it returns data from B that match A. Now in another cell I want to return data from C and when I change B to C it still return data from B not C. How can I get data from C that matches data from my list? Thanks for the help. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
using If fuction with vlookup from list
Thanks so much this work just fine
"Gord Dibben" wrote: You must change the column index number from 2 to 3 =IF(D5="","",VLOOKUP(D5,Table!A:C,3,FALSE)) Gord Dibben MS Excel MVP On Tue, 7 Oct 2008 12:50:28 -0700, Larry wrote: Im working with a list in one worksheet and I have the table list in another worksheet. I want to return a value from the table based on the list selection. I have written this formula. =IF(D5="","",VLOOKUP(D5,Table!A:B,2,FALSE)) and it returns data from B that match A. Now in another cell I want to return data from C and when I change B to C it still return data from B not C. How can I get data from C that matches data from my list? Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Min Fuction | Excel Worksheet Functions | |||
| Which 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 | |||
| For Each Fuction??? | Excel Discussion (Misc queries) | |||
Linear Mode
