Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlooukp horizzaontal...
Assuming i have this wbook with a sheet 4546-015377 and sheet RIEPILOGO. Into sheet 4546-015377 is present a index (is unique from all record) into sheet RIEPILOGO into column A (start from A3) is present a list of index. my problem is: Find from range B1 of sheet 4546-015377 into range of sheet RIEPILOGO into column A, if into column A of sheet RIEPILOGO is present the same index of range B1 of sheet 4546-015377 copy from range of sheet RIEPILOGO F:BQ, and put all value into sheet 4546-015377 started from range A10:C... Note: if into range F of sheet RIEPILOGO is present "9999" insert into A10 of sheet 4546-015377 the value "non trovato", but make the vlooup from range of BM:BQ of sheet RIEPILOGO... +-------------------------------------------------------------------+ |Filename: VLOOKUP_IN_ORIZZONTAL.zip | |Download: http://www.excelforum.com/attachment.php?postid=3865 | +-------------------------------------------------------------------+ -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=471739 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlooukp horizzaontal...
Try HLOOKUP
"sal21" wrote: Assuming i have this wbook with a sheet 4546-015377 and sheet RIEPILOGO. Into sheet 4546-015377 is present a index (is unique from all record) into sheet RIEPILOGO into column A (start from A3) is present a list of index. my problem is: Find from range B1 of sheet 4546-015377 into range of sheet RIEPILOGO into column A, if into column A of sheet RIEPILOGO is present the same index of range B1 of sheet 4546-015377 copy from range of sheet RIEPILOGO F:BQ, and put all value into sheet 4546-015377 started from range A10:C... Note: if into range F of sheet RIEPILOGO is present "9999" insert into A10 of sheet 4546-015377 the value "non trovato", but make the vlooup from range of BM:BQ of sheet RIEPILOGO... +-------------------------------------------------------------------+ |Filename: VLOOKUP_IN_ORIZZONTAL.zip | |Download: http://www.excelforum.com/attachment.php?postid=3865 | +-------------------------------------------------------------------+ -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=471739 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlooukp horizzaontal...
I couldn't quite understand exactly what you are after. Have you looke into the HLOOKUP function? It's the same as VLOOKUP, only it searche horizontally -- MrShort ----------------------------------------------------------------------- MrShorty's Profile: http://www.excelforum.com/member.php...fo&userid=2218 View this thread: http://www.excelforum.com/showthread.php?threadid=47173 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlooukp horizzaontal...
MrShorty Wrote: I couldn't quite understand exactly what you are after. Have you looke into the HLOOKUP function? It's the same as VLOOKUP, only it searche horizontally. I am sorry... But i would want to make the vlookup with VBA ... not is simple fo me:- -- sal2 ----------------------------------------------------------------------- sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204 View this thread: http://www.excelforum.com/showthread.php?threadid=47173 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|