| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
maintain worksheet reference
Glad you got it working there !
what would you do with the IF command? .. =IF(A2="","",VLOOKUP(A2,Sheet2!A:G,7,0)) The IF as used above (=IF(A2="","", ...) is just a simple error trap to return a neat "blank" look in the formula cell should the lookup cell A2 be empty/cleared. It should also help a little with calc performance, as there's no need to calculate further the VLOOKUP if A2 is empty/cleared <g. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "inigo45" wrote in message ... Hallo, I have tried VLOOKUP and HLOOKUP, the datas are in the array in Sheet2 in col. C, so I was successful with =VLOOKUP(B3;Sheet2!C4:G1000;7). Thanks to your thoughts, which brought me to the right formula. BTW Cheers, Juergen -- inigo45 ------------------------------------------------------------------------ inigo45's Profile: http://www.excelforum.com/member.php...fo&userid=5926 View this thread: http://www.excelforum.com/showthread...hreadid=504269 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| worksheet reference returns address instead of value | Excel Worksheet Functions | |||
| Worksheet reference behaving funny | Excel Discussion (Misc queries) | |||
| Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Reference a cell to get worksheet name | Excel Worksheet Functions | |||
Hybrid Mode
