#1
|
|||
|
|||
Can't figure out a formula - Vlookup or something else?
I am having trouble with a formula which should be fairly simple but can't figure it out and it's driving me nuts.
What I'm trying to do: I have two spreadsheets, the first is a list of locations that shows Pass/Fail against 40 Internet Providers. It tells me Pass/Fail so I know what is available for each location. All Headers/Titles/Internet Providers are in Row 1. All Locations are in Column A. The 2nd spreadsheet is a list of each of the 40 Internet Providers, with all available speeds, pricing, etc. A1=Provider, B1=Service Type, C1= IP Type, D1=Download Speed, E1=Upload Speed, F1=Monthly Price. Column A lists each provider but the number of options varies by carrier. For example - ATT has 20 different options, Bell South has 4, Century Link has 30, Comcast has 6, etc. I want to run a formula that will essentially replace the Pass/Fail cells with all available speeds, pricing, etc. Any help is much appreciated. |
#2
|
|||
|
|||
Can't you upload the file?
(Click Go Advanced) |
#3
|
|||
|
|||
See attachments - Thanks
|
#4
|
|||
|
|||
I regret, but I don't understand what you want.
Can you give more examples of expected results? |
Tags |
formula help |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
adding a formula to a figure inserted from visio | Mo_ba | Word | 2 | 10-25-2016 02:19 AM |
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula | innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
Can't figure out formula problem using form controls | Fantabulator | Word | 1 | 10-11-2015 01:24 PM |
IF + VLOOKUP formula help | skyline255 | Excel | 0 | 09-19-2012 05:05 PM |
Help with VLOOKUP formula | pattyr | Excel | 6 | 08-20-2012 02:20 AM |