|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 22nd, 2002, 01:42 PM
|
#1 |
|
Board Regular
Join Date: May 2002
Posts: 74
|
Hi.
When i use this command =IF(ISNB(VLOOKUP(F1;Adres;2;FALSE));0;(VLOOKUP(F1;Adres;2;FALSE))) excel displays only ones the value, and then the formula is gone, so i cannot use it twice. I have made a pull down data cell(sorry for my bad english) i think you say a validate cell where i can choose the proper data. in an older spreadsheet i had to type the data and there the command stays in the cell. is there a way to use vlookup as i want to do now whitout the command getting lost and still having the ease to choose data instead of typing ? Thanks. Rob |
|
|
|
May 25th, 2002, 05:02 AM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
|
Hi Rob,
I'd be happy to take a look at your spreadsheet if you want to email it novulari@hotmail.com just highlight the bits that you want looked at per your post
__________________
:: Pharma Z - Family drugstore :: |
|
|
|
|
May 25th, 2002, 09:07 AM
|
#3 |
|
Board Regular
Join Date: Apr 2002
Location: Cape Town,South Africa
Posts: 234
|
Chris,If you dont succeed,please let me have a go at it.I have alot of knowledge where vlookup is concerned.
 |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
