Home |
Search |
Today's Posts |
#1
|
|||
|
|||
offset and vlookup
can you use a vlookup inside an offset ex: offset(vlookup(c5, a1:d40, 2), 5,3,1,1) did i type in something wrong b/c excel doesnt like that formula -- cutsygurl ------------------------------------------------------------------------ cutsygurl's Profile: http://www.excelforum.com/member.php...o&userid=15041 View this thread: http://www.excelforum.com/showthread...hreadid=275730 |
#2
|
|||
|
|||
Try the following formula... =OFFSET(INDEX(B1:B40,MATCH(C5,A1:A40,0)),5,3) Although, isn't your lookup value in a different sheet from your lookup table? Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=275730 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with VBA | Excel Discussion (Misc queries) |