Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Little Penny Little Penny is offline
external usenet poster
 
Posts: 64
Default Vlookup

Is it possible to use vlookup to return a value if a second cell meets
a certain condition?

For example

A1 -1 B2-2 C3-3 D4-4 H1-?
A2- 1 B2-7 C2-8 D2-9


I want to vlookup the number 1 in column A and return the value in
column cell H1 where column D has a value of 9

In this case it would return the number 9

Or is the some other way to do this


Thanks