paulh

Posts: n/a

lookup

sheet 1
type in to sheet1 d6 (15gr) refer to sheet2 and result in f8 sheet1 to be 3.5
or type in 10gr into d6 sheet 1 and result in f8 sheet 1 to be 2.7

Sheet2
A B
10GR 2.7
15GR 3.5
20GR 5.6

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
Lookup Vector > Lookup Value	Alec Kolundzic	Excel Worksheet Functions	6	June 10th 05 02:14 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Lookup Function Problem	seve	Excel Discussion (Misc queries)	9	February 28th 05 02:46 AM
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 04:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us