LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Formula help - possible vlookup/hlookup combination with IF or oth

HI,

I'm trying to work out a formula that will bring back data from a table as
below

1 2 3 4 5
60 20 10 6 40 5
61 1 25 70 45 12
62 7 70 20 52 10

I need a formula that would compare the x & y axis of the table when given
the values and report back the associated cross value. I was thinking along
the lines of a vlookup and h lookup in combination with an IF statement
somehow. Or is there a specific formula within excel?

Many thanks


--
Adam&ellie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Hlookup, Vlookup and IF in combination?? ronnomad Excel Discussion (Misc queries) 11 January 4th 07 12:41 PM
Combination of Vlookup & Hlookup Sweepea Excel Discussion (Misc queries) 5 May 4th 06 06:18 PM
can hlookup and vlookup be used in combination ? Arul T Excel Discussion (Misc queries) 2 April 20th 06 10:59 AM
SUMIF - HLOOKUP Combination Mark Excel Worksheet Functions 1 February 4th 05 08:03 PM


All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"