instead of using vlookup (and having to change your table around), use index/match instead...
=INDEX(QuoteData,MATCH(D6,'Quote Register'!$E$6:$E$257,0),2) - change the ,2 to whichever column number you need (counting from C) for the other references
if you gave your table headings on your data sheet the same names as on your summary sheet, then instead of having to use a number (, 3 etc) for the column, you could use another match, based on what you wanted to find.
do a bit or reading on inxex/match if you are not familiar with it
Bookmarks