Results 1 to 2 of 2

A complex Lookup function

Threaded View

  1. 02-10-2011, 04:40 AM #1
    alexvl
    alexvl is offline
    Registered User
    Join Date
    02-10-2011
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2007
    Posts
    1

    A complex Lookup function

    You can use the VLOOKUP function to search the first column of a range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells, and then return a value from any cell on the same row of the range.
    Also yopu can use HLOOKUP for a row...

    But what if I want to look up something that is conditioned by 2 values... what can I do?
    Last edited by alexvl; 02-10-2011 at 04:42 PM. Reason: Request to comply to rules
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1