| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula to lookup data in row
Ron,
Thank you sooooo much! ... I would never have come up with that myself... Aloha! ... dave... ?B?Um9uIENvZGVycmU=?= wrote in : Try something like this: D2: =IF(COUNTIF(F2:N2,B2+1),INDEX(F2:N2,1,MATCH(B2+1,F 2:N2,0)-4)/A2,"no match") Is that something you can work with? *********** Regards, Ron XL2002, WinXP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to lookup data and enter it in another WB | Excel Worksheet Functions | |||
| Formula to lookup matching data | Excel Discussion (Misc queries) | |||
| how do I lookup data based on two columns of data | Excel Worksheet Functions | |||
| Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
