VLOOKUP

M

Martin Koenig

I have 4 colums of data based on the results of 2 columns I would like
to have the value of the third & 4th column placed in the appropriat
cells.

Example of the data I am trying work with is shown below:

Specification|Grade UNS|P_Number|G_Number
SA-516 | 60 | 1 | 1
SA-516 | 70 | 1 | 2
SB-111 | C71500 | 34 | NA
SB-111 | C44400 | 32 | NA
SB-111 | C60800 | 35 | NA

I have created 2 comboboxes on a userform to select the specification
and grade and place it the applicable cells on the worksheet, but I
just can't seem to find a way to use the vlookup for 2 columns.

Any help would be appriciated.
Kind Regards
Martin
 
A

Alan Beban

It's hard to tell exactly what result you want, but if the the functions
in the freely downloadable file at http://home.pacbell.net/beban are
available to your workbook, with the data in A2:D6, with the
specification in F1 and with the Grade in G1, (and assuming the vertical
bars are not really part of your data) the following, array entered into
a four-cell row, will return the data from the requested line:

=ArrayRowFilter2(ArrayRowFilter1(A2:D6,1,F1),2,G1)

Alan Beban
 
K

Kevin T. Ryan

To use a vlookup for 2 columns, you might want to try an array formula.
for example: {=SUM(IF((A1:A6=10)*(B1:B6=20),C1:C6))}. Note: the {}
are obtained by hitting ctr+shft+entr after you enter the formula. Use
MS Help to get more info on array formulas, but I think that's what
you're after.
 
Top