Posted to microsoft.public.excel.worksheet.functions

Frances C[_2_] Frances C[_2_] is offline

external usenet poster

Posts: 31

vlookup and hlookup formula, a good challenge

to beginu thanks for your help. I need a formula for the following
information. I have a table with the following information:
1 2 3 4
Rose 5% 101 102 103 104
Rose 10% 201 202 203 204
Rose 15% 301 302 303 304
Jack 3% 401 402 403 404
Jack 6% 501 502 503 504
Jack 9% 601 602 603 604

I need a formula that when I request "Rose @ 15% @ 2" My answer is 302

Hope you can understand, Thanks

Frances

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
vlookup and hlookup in the same formula	lindsayhyle	Excel Discussion (Misc queries)	6	August 3rd 07 03:46 PM
Vlookup & hlookup	Aitchy	Excel Worksheet Functions	3	May 29th 07 05:10 AM
VLOOKUP , HLOOKUP	bijan	Excel Discussion (Misc queries)	4	January 7th 07 08:04 PM
can i use vlookup and hlookup together	Tinman09	Excel Discussion (Misc queries)	1	November 7th 05 09:50 PM
formula using both vlookup & hlookup	xFreeAdvice	Excel Worksheet Functions	2	November 17th 04 11:19 PM

All times are GMT +1. The time now is 05:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us