vlooukp horizzaontal...

[sal21]

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...

[MrShorty]

I couldn't quite understand exactly what you are after. Have you looked into the HLOOKUP function? It's the same as VLOOKUP, only it searches horizontally.

[sal21]

I couldn't quite understand exactly what you are after. Have you looked into the HLOOKUP function? It's the same as VLOOKUP, only it searches horizontally.

I am sorry...
But i would want to make the vlookup with VBA ... not is simple for me:-)

[JNW]

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
>
>