Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula - help??
A sample of the data I'm working with looks like this:
Formations 313** 313**313** 317** 317**317** TSC 21960000 12.737 21961000 10.259 21962000 11.584 12.860 24.542 21963000 13.155 21964000 14.038 21965000 14.333 15.511 32.200 21967000 11.293 12.762 24207000 I am trying to write a formula which will return the value of, for example, TSC 21962000 and formation 317**. I 'm sure it's easy but for the life of me I can't get it to work. Can someone help please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |