|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Vlookup information from blank cell
Thanks Max
"Max" wrote:
Place in B1, then array-enter the formula ie press CTRL+SHIFT+ENTER
instead of just pressing ENTER:
=INDEX($D$1:$D$7,MATCH(TRUE,$C$1:$C$7=A1,0))
Copy B1 down to B7. Adapt the ranges to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Doug" wrote:
Can anyone help please.
I wish to return the value from D4(saucer)in cells B2 and B7.
My worksheet contains a few thousand rows and "saucer" will always
correspond to a blank cell.
I have been using the formula below,but this does not recognise a blank cell.
VLOOKUP(A2,$C$1:$D$8,2,FALSE
A B C D
1 prod3 oven prod1 cup
2 saucer prod2 kettle
3 prod1 cup prod1 cup
4 prod2 kettle saucer
5 prod3 oven prod3 oven
6 prod1 cup prod2 kettle
7 saucer prod2 kettle
8 prod3 oven prod1 cup
|