ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Choosing a service with a formula (https://www.excelbanter.com/excel-programming/388937-choosing-service-formula.html)

[email protected]

Choosing a service with a formula
 
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



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com