| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then, vlook up and list box
Hi,
A1 is a list box with 12 options to pick from B1 is a yes or no field C1 needs to look at B1, if yes, look at A1, see the chosen option and go to a separate worksheet to pull the corresponding cost. If no, then enter $0.00. I've playing with this formula but not getting anywhere. Is it possible to do this? =IF(ISNA(VLOOKUP(GB3,RATES!$A$67:$B$78,2,FALSE))," ",VLOOKUP(GB3,RATES!$A$67:$B$79,2,FALSE)) Kathleen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| VLOOK UP | Excel Discussion (Misc queries) | |||
| If with Vlook up | Excel Discussion (Misc queries) | |||
| How do I use drop down list selections/values in a vlook up formu. | Excel Discussion (Misc queries) | |||
Threaded Mode
