Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

H look up

I know how to use v look up. how to use h look up in ms excel. how is needful, when to implement, how it works??

Posted by on

  • Anonymous Jul 17, 2008

    every moment i used my desktop computer... its always restarting again... specialy when i burning a cd's.. may i know whats the problem of my pc.. thanks. God Bless..



1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

Hi vrusha,

Your right hlookup is very simular to vlookup, the key difference is it searches along the top row of the table, finds the matching data and gives you one of the below cells (depending on how you write the formula), just think of a vlookup on it's side.

The formula works like this:
=HLOOKUP(lookup value, table, row_index_number, range_lookup)

lookup value = is the value you want to match against the table i.e. ABBA

table = the range of cells that make up the table you want to search i.e. A1:D300

row_index_number = the number of rows from the top of the table you want to get the value from, 1 is the top of the table, 2 is directly below

range_lookup = if you want an exact match type FALSE, if you want the nearest match type TRUE

Posted on Jul 19, 2008


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet

if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
install it and success!

Feb 22, 2011 | Computers & Internet

1 Answer

Parts of ms word 2007?

The newer versions (latest) of MS Office (Word, Excel, Access, PowerPoint, etc) were designed to interact with one another. You can pull a file from MS Word, and place it in Excel, PowerPoint, etc and Vise Versa.

Please let me know if you need further assistance.


Guru, Premium Expert @

Jul 19, 2010 | Microsoft Office Excel 2007

10 Answers

Excell Password

Would you like to recover excel file password so just try PDS Excel password recovery software this software quickly works on your password protected Excel file and get back your original Excel file password, This Microsoft Excel file password recovery software magnificently recover password MS Excel file and also let you use your locked XLS and XLSX file again without creating any problem more. With the help of MS Excel sheet password recovery software you can easily recover password MS Excel sheet with fully previous data of your locked Excel file. PDS Excel file unlocker tool gives you free Excel unlocker software which shows you first three characters of your original Excel file password. if you want to recover whole Excel file password then you can get full version software.

Free Excel Password Recovery
Buy Excel File Unlocker

Mar 04, 2008 | Microsoft EXCEL 2004 for Mac

2 Answers

How to Crack Excell sheet's Password

Mar 03, 2008 | Computers & Internet

1 Answer

MS Excel

Can you please provide any additional information, including error messages generated by Excel? Without knowing the specific error message, your surest solution is to completely uninstall Microsoft Office by going to your Control Panel and double-clicking "Add/Remove Programs". Then, once Microsoft Office is uninstalled, reinstall it using the CD.

Nov 12, 2007 | Computers & Internet

4 Answers

Short keys of MS Excel

short key for minimize word exel window?

Nov 10, 2007 | Computers & Internet

1 Answer

Learn about Microsoft Excel 2000

Dear Mehra, Go to the following link and look at the Excel course you would like to follow. I would also suggest that you obtain a Microsoft Step-by-Step manual to assist you with Excel. This manual will guide you through all the necessary aspects for your MOS Exam. You can write you exam at any Microsoft certified testing center in your area. Hope this helps you in your venture and good luck. Rgds DeltaC

Sep 12, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

180 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18419 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides