VLOOKUP AND HLOOKUP

[pratap]

Dear Sir,
I like to learn VLOOKUP & HLOOKUP facilities of Excel. please advise/describe.

regards,

(M K Pratap)

 

[erik.van.geit]

Dear Sir,
I like to learn VLOOKUP & HLOOKUP facilities of Excel. please advise/describe.

Hello, pratap
Welcome to the Board !!!!!

you are posting in a forum
many users - in fact all users - can answer to your question

you posted your question in the "INTERNATIONAL" forum
on the main page displaying all forums
http://www.mrexcel.com/board2/index.php
you can also choose for
the "EXCEL QUESTIONS" forum, just above "INTERNATIONAL" forum
there you will get more chance to get replies from the "very large community" of this board ! (the "INTERNATIONAL" forum is not visited as much and serves mainly for non-english questions)

two answers to your question
1. you can do a search on this board (see link on top of this page)
examples
http://www.mrexcel.com/board2/viewtopic.php?t=175120&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=174839&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=170977&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=170377&highlight=vlookup
2. you can type in any cell the equal sign: the "name box" (where normally the cellreference is displayed) will turn in a dropdown-menu where you will get some choises ...
3. you can click the helpmenu and type VLOOKUP, there are some good examples in the helpfiles

you may ask your specific question here if you want ...
what would you like to do specifically ?

kind regards,
Erik

 

[erik.van.geit]

the yellow range is named "data"

Map3
	A	B	C	D	E	F	G
1					article	number	price
2	article4	price4	number4		article1	number1	price1
3					article2	number2	price2
4					article3	number3	price3
5					article4	number4	price4
6					article5	number5	price5
7					article6	number6	price6
8					article7	number7	price7
9					article8	number8	price8
10					article9	number9	price9
11
12					DATA
Blad1

 

[Greg Truby]

http://www.mrexcel.com/wiki/index.php?n=ExcelWiki.VLOOKUPFunction

 

[pratap]

Dear Sir,
I like to learn VLOOKUP & HLOOKUP facilities of Excel. please advise/describe.

regards,

(M K Pratap)

Dear Sir,
Thank you very much.
After reading the solution given by you about VLOOKUP Function thru International-Forum of ‘MrExcel.com’ now, I start using this function while working with Excel.

regards,

(M K Pratap)[/quote]