Thread: select value in table based on values entered in multiple cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dungan dan dungan is offline
external usenet poster
  
Posts: 411
Default select value in table based on values entered in multiple cells
This is how I would do it:

table layout:
A B C D E
Size Type Quality SizeTypeQuality Price

The formula in column d:

=a1&b1&c1 Copy Down





So in another worksheet:
A B C D2
1 Size Type Quality Price
2

Enter the variables in row 2

The formula in d2:
=vlookup(a2&b2&c2,'Table'!D1:E12,2,false)

Reply With QuoteReply With Quote