pinmaster

Posts: n/a

best formula for finding a cell value?

Hi,
Try something like this:
A1 = direction
B1 = Row
C1 = HLOOKUP(A1,your_range,B1,0)

HTH
JG

--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=481017

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using contents of a cell in a formula	Mike	Excel Discussion (Misc queries)	4	June 9th 05 03:10 AM
Can a Formula in Cell X modify Cell Y?	alMandragor	Excel Discussion (Misc queries)	7	February 10th 05 09:51 PM
Cell shows formula and not the result of the formula.	stumpy1220	Excel Worksheet Functions	2	January 14th 05 05:11 PM
Cell shows formula and not the result of the formula.	stumpy	Excel Worksheet Functions	2	January 14th 05 04:44 PM
looking for a formula	Amanda	Excel Worksheet Functions	5	January 5th 05 07:37 AM

All times are GMT +1. The time now is 04:43 AM.

About Us

"It's about Microsoft Excel"