| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to current row in formula
Hi
What do you mean when you say it doesn't work? Does it give an answer - but no the answer you expect? Does it give an error value? Jarek's suggestion is correct, for the question you asked. If the formula were entered in say cell A10 of Sheet1, then it would return the value from Row 11 of Sheet4, for the Column value that appears in Row2 of that sheet, which matches the value in Cell L3 of Sheet1 Can you post a small sample of the data on Sheet4, and what you have entered in L3 -- Regards Roger Govier "willemeulen" wrote in message ... Jarek Kujawa;350460 Wrote: =HLOOKUP(L3,Sheet4!B2:AE35,ROW(),FALSE) Does not seem to work Kajawa :( -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98040 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refer to Another Spreadsheet in a Formula | Excel Worksheet Functions | |||
| Refer to formula in another sheet | Excel Discussion (Misc queries) | |||
| How to refer to current column in a formula? | Excel Discussion (Misc queries) | |||
| how to I refer to current workbook without using its name? | Excel Worksheet Functions | |||
| How do I set upa formula to refer back to that box to get the sum. | Excel Worksheet Functions | |||
![Roger Govier[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
