Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is my lookup on the same spreadsheet. I does what I need it to.
=IF(ISNA(VLOOKUP(F18,$AH$1:AS$2000,12,0)),"",VLOOK UP(F18,$AH$1:AS $2000,12,0)) The PROBLEM, is how do the I get the VLOOKUP to formula to choose any cell with the service i.e, The service is "Good" vlookup has located that service but how do I get the formula of one cell to be any cell in a column Service "Good" is on line AH1, but I would like to have cell AJ1 to accept any date time shown in column c1 to c2000. Thanks JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with choosing formula | Excel Worksheet Functions | |||
Formula help for choosing from a set of values | Excel Worksheet Functions | |||
Excel formula(?) for choosing only 1 cell.. | Excel Discussion (Misc queries) | |||
Choosing a formula to used based on a codition fulfilled | Excel Discussion (Misc queries) | |||
Difference between a Service Release and a Service Pack? | Excel Programming |