Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin Koenig Martin Koenig is offline
external usenet poster
 
Posts: 6
Default VLOOKUP

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