| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A function to return the value of a blank cell
Hi
Is it possible to write a function that will give me the value/text entered in column 3 (supplier) when cloumn 2 has the highest number to a different cell that i can then link to a Word doc. I have tried different functions without luck. Date PO: NO Supplier Orderd By Goods Description 19/07 100 20/07 101 21/07 102 22/07 103 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
A function to return the value of a blank cell
Try this....
=VLOOKUP(MAX(B:B),B:C,2,FALSE) Vaya con Dios, Chuck, CABGx3 "Haz" wrote in message ... Hi Is it possible to write a function that will give me the value/text entered in column 3 (supplier) when cloumn 2 has the highest number to a different cell that i can then link to a Word doc. I have tried different functions without luck. Date PO: NO Supplier Orderd By Goods Description 19/07 100 20/07 101 21/07 102 22/07 103 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Function (include Blank Cells and Zeros) | Excel Discussion (Misc queries) | |||
| Return an empty or blank cell value? | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Need Excel Function that will return # of char in preceding cell | Excel Discussion (Misc queries) | |||
| Need Excel Function that will return # of char in preceding cell | Excel Worksheet Functions | |||
Linear Mode
