| 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 |
| 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 | |||
Threaded Mode
