When I select from drop down menu I would like the next column to populate a specific cost.

Posted to microsoft.public.excel.worksheet.functions

marley

Posts: n/a

When I select from drop down menu I would like the next column

Where does the formula =IF(ISBLANK(A2),"",VLOOKUP(A2,LU_ProdCost,2,0))
go?

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop down menu with emp name then autopopulate with supervisor...	Paul (ESI)	Excel Discussion (Misc queries)	10	August 28th 07 07:06 PM
Protect Workbook vs Worksheet??	Dan B	Excel Worksheet Functions	3	November 7th 05 09:02 PM
multiple select from the drop down list in excel. list in one sheet and drop down in	sriramus	Excel Discussion (Misc queries)	5	October 27th 05 06:55 PM
Drop down menu	Steve A via OfficeKB.com	Excel Worksheet Functions	1	May 21st 05 12:57 AM
How to populate column with formula based on value in cell	Cameron Stewart	Excel Worksheet Functions	2	November 2nd 04 01:36 AM

All times are GMT +1. The time now is 07:41 AM.

About Us