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

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

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

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