You are here: Technology, Web & Business Forum
: Web Development
: Search Engines & Directories
:
How do I lookup the header of the column based on the column my search term is in?
|
Welcome to the Technology, Web & Business Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| Search Engines & Directories Discuss topics about Search Engines and website directories
|
 |
|
|
LinkBack | Thread Tools | Display Modes |
05-13-2008
|
|||
|
|||
How do I lookup the header of the column based on the column my search term is in?
I have a list of companies and their address on one worksheet. On the other worksheet I have the list of counties at the top of each column and the cities for each county listed below them. I would like for excel to look up the county of the business that the city is in. This is the formula that I've tried =HLOOKUP("G3",'UTAH COUNTIES'!B12:BG97,1) G3 is the cell that the city is listed in, B12:BG97 is the selection of cells that the county headers and cities are listed in. Someone help this is killing me!
__________________
Powered by Yahoo! Answers 
|
|
05-14-2008
|
|||
|
|||
|
put Sheet2! before the "g3"
=B34(Sheet2!B2,G2) where sheet 2 is the name of the other sheet on re-reading, this is not the solution, lemme check my excel to recreate your problem
__________________
Powered by Yahoo! Answers
|
Linear Mode
