just change the index range on what column you want to return
=INDEX(quote!$C$2:$C$377,MATCH($L13,quote!$A$2:$A$377,0))
saymanufacturers column in quotes table > quote!$C$2:$C$377
Model Number column in quotes table > quote!$D$2:$D$377 then
=INDEX(quote!$D$2:$D$377,MATCH($L13,quote!$A$2:$A$377,0))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks