View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PhilipsBernard PhilipsBernard is offline
external usenet poster
 
Posts: 7
Default selecting a cell based on lookup with VBA

Hi!

I have the following problem: Sheet 1 is a matrix of which the two axes
describe two variables. Sheet 2 contains values of variable 1 in column A and
values of Variable 2 in column B. Based on the pair of these values in column
A and B, I want to look up for each row the corresponding value from the
matrix (based on the values of variable 1 and 2). How can this be solved
using VBA?

Thanx for your suggestions!